return value from list many conditions

C

Casey C

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