Complicated Iserror and Vlookup

[lcmast]

I am trying to do a complicated vlookup. First I want to look up a value in one sheet. If found, return that value. If not found, look it up in another table. If found return that value. If not, look it up in yet a third table and return that value. I can't seem to keep all of the parentheses and iserrors straight.

 

[hiker95]

lcmast,

Try one of the following:

VLookUpMulti
By jindon
http://www.mrexcel.com/forum/showthread.php?t=344561&highlight=muvlookup

VLOOKAllSheets
http://www.ozgrid.com/VBA/VlookupAllSheets.htm

 

[Haseeb Avarakkan]

Hello,

What is the output of VLOOKUP? text or number?

Please see the below link. It may help you...!

http://www.mrexcel.com/forum/showthread.php?t=540315

 

[lcmast]

What I have so far is the following:

=IF(ISERROR(VLOOKUP(X4,'Aspen - OMS Print'!$A$2:$B$300,2,FALSE)),IF(ISERROR(VLOOKUP(X4,'SO v3'!$J$2:$O$548,6,FALSE)),VLOOKUP(X4,Original!$X$2:$Y$323,2,FALSE)))

This gives me back the right answer if it makes it to the third vlookup. However, otherwise it returns "FALSE". I want it to look up x4 in the Aspen-OMS Print table first. If it finds a match, return the name in the next column. If it doesn't, then lookup the same x4 in another table - SO v3. If it finds a match, return the result from 6 columns over. Lastly, if all else fails, look up x4 in the table - Original - and return the value in the next column.

 

[Aladin Akyurek]

What I have so far is the following:

=IF(ISERROR(VLOOKUP(X4,'Aspen - OMS Print'!$A$2:$B$300,2,FALSE)),IF(ISERROR(VLOOKUP(X4,'SO v3'!$J$2:$O$548,6,FALSE)),VLOOKUP(X4,Original!$X$2:$Y$323,2,FALSE)))

This gives me back the right answer if it makes it to the third vlookup. However, otherwise it returns "FALSE". I want it to look up x4 in the Aspen-OMS Print table first. If it finds a match, return the name in the next column. If it doesn't, then lookup the same x4 in another table - SO v3. If it finds a match, return the result from 6 columns over. Lastly, if all else fails, look up x4 in the table - Original - and return the value in the next column.

Try...

=LOOKUP(REPT("z",255),CHOOSE({1,2,3,4},"Not Found",
    VLOOKUP(X4,Original!$X$2:$Y$323,2,0),
    VLOOKUP(X4,'SO v3'!$J$2:$O$548,6,0),
    VLOOKUP(X4,'Aspen - OMS Print'!$A$2:$B$300,2,0)))

 

[lcmast]

I believe that worked! Thanks.

 

[Aladin Akyurek]

I believe that worked! Thanks.

You are welcome. & Thanks for providing feedback.