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
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