IF statement w/ 2 Vlookups

[kal8v9]

Hi-

I need help. I have a IF statement and I want 2 vlookups in it. It says this =IF(AB18="Outbound",VLOOKUP(A18,'Shipper Number'!$A$1:$E$17,4,FALSE),VLOOKUP(K3,Plants!$B$1:C$5,2,FALSE)). Well the first vlookup is returning a #N/A. I want the statement to read if the cell reads outbound look at shipper number and return #, but if the shipper number doesn't match look at tab plants and return plant number. The first vlookup is returning a #N/A and it is causing the 2nd vlookup not to work.

Hope that sounds ok, and you can understand it.

Thanks,
Kelly

 

[sijpie]

use a isna() function to check first. so

=IF(AB18="Outbound",IF(ISNA(VLOOKUP(A18,'Shipper Number'!$A$1:$E$17,4,FALSE)),VLOOKUP(K3,Plants!$B$1:C$5,2,FALSE)),VLOOKUP(A18,'Shipper Number'!$A$1:$E$17,4,FALSE))

So now if the first returns #NA it does the second, if it does not return #NA it shows the result