Forum Discussion
Looking up values in Tab A based on values in Tab B (column A, column C)
I am trying to pull value into a row / cell in Tab A based on values mentioned in column / row A, column / row C in Tab B. For example, when I select a value "1" or "2" I am planning to get value "low", "high" & another value "unimportant" , "important" - which is in the Tab B (column A & column c) at the same time.
Please let me know if there is a way to do it.
Modify the VLOOKUP by adding IFERROR. The correct syntax is illustrated here.
=IFERROR(VLOOKUP($A5,Source,2,0),"")
Please also understand that the answers we've given you are not the only way to accomplish something like this. One of the wonders of Excel is that there are always multiple routes to the same destination; which of those routes is ideal can depend a lot on the bigger picture. What @Riny_van_Eekelen and I have demonstrated here are a couple of the more basic ways to retrieve a value from another table.
7 Replies
mgroms Almost everything is possible, but it's difficult to visualise what you need. Can you upload an example of your workbook, indicating what needs to be pulled from where to where and with what logic?
Riny_van_Eekelen, thank you for your response. I have uploaded a sample excel document with 2 tabs here. I was looking into INDEX / MATCH. Please let me know if you have any solutions.
INDEX/MATCH would do it. So does VLOOKUP, as I've used it in the attached
I also incorporated a few tricks I've learned just in the last week from @Riny_van_Eekelen (wanted to credit him as a great teacher)... and you'll see those in the data validation process. in particular. Your source table has been turned into a full Excel Table; I then off to the right isolate the values that you wanted to use as Data Validation in Tab 1......so now as you add to Tab2's table, the data validation list is automatically expanded.
These new Dynamic Array capabilities of Excel are very powerful tools to incorporate in your own toolbox.
