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.
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.
mathetesThank you for your help, I really appreciate your's and @Riny_van_Eekelen time and assistance. Its working fine now.