• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested Vlookup

A

Aspur

New Member
Hello All

I have a vlookup with Iferror and it works great, however, I need to add another lookup and am at a loss for how to do this.

The current lookup is as so: =IFERROR(VLOOKUP(A:A,'OBS_Replaced by Parts'!A:A,1,0),VLOOKUP(A:A,'OBS_Replaced by Parts'!Q:Q,1,0))

I need to add another Vlookup: VLOOKUP(A:A,'OBS_Replaced by Parts'!AB:AB,1,0))

I suspect it is some kind of nesting but I have been unsuccessful trying to figure it out. Basically I'm asking excel to look here first A:A,'OBS_Replaced by Parts'!A:A,1,0; if you don't find the data there, the go to here A:A,'OBS_Replaced by Parts'!A:A,1,0; and it you don't find my data there this is the last place OBS_Replaced by Parts'!AB:AB,1,0. If nothing is found in any of the data sources, then OK.

Is this possible?
 
vletm said:
Aspur
Create a SAMPLE Excel-file which has same features and enough SAMPLE data ... which isn't confidential.
Click to expand...
I actually just figured it out after much trial and error.

For anyone else who is wondering what the answer is see below.

=IFERROR(VLOOKUP 1,IFERROR(VLOOKUP 2,VLOOKUP 3))

So my formula looks like this: =IFERROR(VLOOKUP(A:A,'OBS_Replaced by Parts'!A:A,1,0), IFERROR(VLOOKUP(A:A,'OBS_Replaced by Parts'!Q:Q,1,0), VLOOKUP(A:A,'OBS_Replaced by Parts'!AB:AB,1,0)))
 
Thank you for your responses. I'm sorry I could not load the data. In the future, I will create sample data with no confidential information.
 
You must log in or register to reply here.
Back
Top