How can I do multiple 3 or more vlookup formulas into one formula until it gets the result?
How can I do multiple 3 or more vlookup formulas into one formula until it gets the result?
You can nest them with IFERROR statements.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello,
Can I use the same lookup value more then once in the same formula?
For example-
=IFERROR(VLOOKUP(B2,'[QUICKBOOKS PRODUCT DATEBASE.xlsx]QUICKBOOKS DATBASE'!$A:$R,18,FALSE),VLOOKUP(E2,'[QUICKBOOKS PRODUCT DATEBASE.xlsx]QUICKBOOKS DATBASE'!$F:$R,13,FALSE))
I would like to use value E2 to look up from a different part of the same worksheet
Yes, but you need to be canny about the order in which you do it.
What order can I do it to make it work?
Generally speaking, if you are nesting, the first one needs to go innermost.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks