Forum Discussion
Looking up values in Tab A based on values in Tab B (column A, column C)
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.
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.
Riny_van_Eekelen& mathetes Thank you for your assistance in that. Is there a way we can have the column B & C values auto populate when we change column A's values without having to drag the formula to other cells so that N/A doesn't appear ? Thank you for your assistance in that. Is there a way we can have the column B & C values auto populate when we change column A's values without having to drag the formula to other cells so that N/A doesn't appear ?
I am also researching, if you have any suggestions, please let me know.
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.
mgroms In this case I suggest a VLOOKUP combined with MATCH as in the attached workbook, The match part can easily be replaced by 2 and 3 respectively. Whatever you prefer.