Hi, can someone help me fill out the attached worksheet with a formula I'm looking for? In the tab Vlookup, please write me a formula that would Vlookup the number column "A" to the table in tab "Table1". If it doesn't find the number, it will Vlookup in the tab "Table2" to find the result?
Thank you very much
One way:
=IFERROR(IFERROR(VLOOKUP(A2,Table1!A:B,2,0),VLOOKUP(A2,Table2!A:B,2,0)),"Not found in two tables")
Edit: Just noticed your profile showing Excel 2003, but file with 2007 or later. Please confirm which version you are using.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Try this..
Formula:
Please Login or Register to view this content.
Excel Forum2.xlsx
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks