Referencing lists in a nested IF formula

J

JTinAtlanta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UPDATED - Referencing named Ranges within a Nested IF formula 1
Drop down list control value in vba 2
Don't want to insert a partial row 3
Help requested for nested conditional formulas referencing other c 3
Looking for formula to place score in a range of scores 1
Formula referencing a changing range?? 3
Can you put a formula on a field that requires user input? 2
adding a forumla to cells with formula in them already 1

Top