Referencing lists in a nested IF formula

G

Guest

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
A challenge: referencing cell contents in nested function formula 3
Formula referencing a changing range?? 3
IF(FIND Formula gives #VALUE! error 6
Help with a formula and cell referencing. 2
formula to move a scored number to a score sheet 1
Data Validation List from a Dynamic Named Range on Another Workshe 5
Nested formula to search a text string and return specific text 10

Top