Thanks for the quick replies 🙂
Home ›
Robin Hernandez › Posts
Posts by Robin Hernandez
3 posts shown.
Kyle Johnson2 said:Check out this link for VLOOKUP tips. If you need to set up dependent drop-down lists, there's a link for that too.
Thanks 🙂
One more thing: Is it possible to add buttons that just bump a value up by 1? Like, if a cell has a 5 in it, I hit a button and it jumps to 6?
Excel; I need to merge two different tables (if that makes sense)
The table on the left side shows #question1|Question|Answer (selected from a dropdown list)|A numerical value tied to that answer
Is there a way to automatically pull that number from the table on the right? For example, if Answer3 is picked for question1, I want cell D2 to automatically show the number 4 (the table on the right acts as a 'legend' for each question)
I've been digging through Excel tutorials for Excel, but I'm still struggling—I'm pretty new to all this.
The table on the left side shows #question1|Question|Answer (selected from a dropdown list)|A numerical value tied to that answer
Is there a way to automatically pull that number from the table on the right? For example, if Answer3 is picked for question1, I want cell D2 to automatically show the number 4 (the table on the right acts as a 'legend' for each question)
I've been digging through Excel tutorials for Excel, but I'm still struggling—I'm pretty new to all this.