return value from list many conditions
 

Hello All!

I need help with the following:

I have 3 columns in sheet1:

CARRIER - MAKE - DESTINATION

In Sheet 2 I have 2 spreadsheets (AT & FE) titled:
DESTINATION - TRUCK - BAKKIE - NORMAL on each.

I need to do the following:

In sheet 1 I need a formula to check
a) if the CARRIER in sh1 matches CARRIER in sh2, use spreadsheet that
it relates to(either AT or FE)

b)match the DESTINATION in the spreadsheet

c)if the MAKE is TRUCK, return value in column 2, if it's BAKKIE,
return value in column 3 etc.

I have tried the following but it returns FALSE:


--
Casey C
------------------------------------------------------------------------
Casey C's Profile: http://www.excelforum.com/member.php...o&userid=29090
View this thread: http://www.excelforum.com/showthread...hreadid=489759