Vlookup

[sburkhar]

I need a VLOOKUP with two conditions

If G13 is used then complete the VLOOKUP (G13 will not be used often)
If not, and E13 is used then complete the VLOOKUP
Below is what I have for E13 (E13 will be used 90% of the time)


IF(ISERROR(VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE)),"",VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE))

 

[Excelestial]

IF(ISERROR(VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE)),VLOOKUP(G13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE),VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE))

 

[sburkhar]

Excellent! But, I can't have it say #REF or #N/A if the cells are empty. I thought the IF(ISERROR took care of that.

This was originally written in a 97-2003 workbook, but I'm now working in 2007.

 

[Excelestial]

=IF(NOT(ISERROR(VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE))),VLOOKUP(E13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE),
IF(NOT(ISERROR(VLOOKUP(G13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE))),VLOOKUP(G13,'[2011 FIAT VLOOKUP.xls]Sheet1'!$B:$L,4,FALSE),""))

 

[sburkhar]

Holy Crap!!!
I'll give it a try................I'm goin' in!

 

[sburkhar]

Works perfectly!! I could have written that you know.............only mine would have been much shorter and wouldn't have worked.

thanks!

 

[Excelestial]

ROFL! Happy to help. lol

 

[snoopyhr]

Since you have version 2007, see if this works for you.

=IFERROR(IFERROR(VLOOKUP(E13,'[2011 fiat.xlsx]Sheet1'!B:L,4,0),VLOOKUP(G13,'[2011 fiat.xlsx]Sheet1'!B:L,4,0)),"No match")