Hello,
I am trying to come up with a formula that will review two lists (A2:A6 and D2:D6), and if any cells in the lists match, then return the value of that match from Column B. There would not be multiple answers to this (Option 1 and Option 2 would not be listed in D2:D6). Example below: "Option 1" matches both lists, so the return value should be "5".
Thank you for any insights!
I am trying to come up with a formula that will review two lists (A2:A6 and D2:D6), and if any cells in the lists match, then return the value of that match from Column B. There would not be multiple answers to this (Option 1 and Option 2 would not be listed in D2:D6). Example below: "Option 1" matches both lists, so the return value should be "5".
Excel 2016 (Windows) 32 bit | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | List 1 | Amounts | List 2 | |||
2 | Option 1 | 5 | n/a 1 | |||
3 | Option 2 | 10 | n/a 2 | |||
4 | Option 3 | 15 | Option 1 | |||
5 | Option 4 | 20 | n/a 3 | |||
6 | Option 5 | 25 | n/a 4 | |||
Sheet1 |
Thank you for any insights!