Referencing lists in a nested IF formula
 

All,

I am trying to create a formula that will evaluate a cell against 3 lists,
populating another cell with the value assigned to the matching list or
feeding it with a 0 if it doesn't match values in any of the lists. Is this
possible? Thank you in advance!!!

Cell_1 : 'Manufacturing'
Cell_2 : <cell where returned value needs to be placed

LIST_1 LIST_2 LIST_3
'Shipping' 'Medical' 'Construction'
'Engineering' 'Banking' 'Entertainment'
'Manufacturing

Cell_3 = 1 (LIST_1 score)
Cell_4 = 5 (LIST_2 score)
Cell_5 = 9 (LIST_3 score)

Logic:
IF Cell_1 in LIST_1, then Cell_2 = Cell_3 ELSE
IF Cell_2 in LIST_2, then Cell_2 = Cell_4 ELSE
IF Cell_3 in LIST_3, then Cell_2 = Cell_5 ELSE
Cell_2 = 0
END-IF
END-IF
END-IF

Regards,

JT

See your later post

Biff

"JTinAtlanta" wrote in message
...
All,

I am trying to create a formula that will evaluate a cell against 3 lists,
populating another cell with the value assigned to the matching list or
feeding it with a 0 if it doesn't match values in any of the lists. Is
this
possible? Thank you in advance!!!

Cell_1 : 'Manufacturing'
Cell_2 : <cell where returned value needs to be placed

LIST_1 LIST_2 LIST_3
'Shipping' 'Medical' 'Construction'
'Engineering' 'Banking' 'Entertainment'
'Manufacturing

Cell_3 = 1 (LIST_1 score)
Cell_4 = 5 (LIST_2 score)
Cell_5 = 9 (LIST_3 score)

Logic:
IF Cell_1 in LIST_1, then Cell_2 = Cell_3 ELSE
IF Cell_2 in LIST_2, then Cell_2 = Cell_4 ELSE
IF Cell_3 in LIST_3, then Cell_2 = Cell_5 ELSE
Cell_2 = 0
END-IF
END-IF
END-IF

Regards,

JT