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.
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.
Last edited by stockgoblin42; 05-22-2013 at 03:58 PM.
live logic & long prosper
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.
Note that an array formula is put have Ctrl + Alt + Enter to make "curly" ({}) bracketsPlease Login or Register to view this content.
Last edited by dluhut; 05-22-2013 at 04:11 PM.
I figured out the relationship:
only 5 IFS! and no table needed!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks