Assign Letter from list based on two conditions.

[stockgoblin42]

Hi, I have a non-uniform list of letters that I'd like to pick one from based on the values of two cells, L26 and P28. To put this into a formula do I really need to do a 25 deep nested IF statement or can I do it another way?

Thanks for any help.

[dluhut]

You can use vlookup. But you'll need a helper column.

i.e. on column A, make it as 1;1 (cell A2), 1;2 (cell A3), ... ... , 5;5 (cell A6) etc

and then on E1, the vlookup will be

Please Login or Register  to view this content.

If you don't want a helper column, you can do an array Vlookup with IF inside it.

Please Login or Register  to view this content.

Note that an array formula is put have Ctrl + Alt + Enter to make "curly" ({}) brackets

[stockgoblin42]

I figured out the relationship:

Please Login or Register  to view this content.

only 5 IFS! and no table needed!