Hello,
Please see attached spreadsheet.
I would like a formula in column G, that if matches/looks up J, K and L in the table next to it starting at N2.
I have two undefined variables that I have called "other" and "level".
"Other" is anything that is not listed in column N such as "XX" in my example.
"Level" could be any number between 0-4. There are two columns P (for anything level 3) and Q (for anything other than 3).
Let me know if this needs more explaination...
Any help is appreciated!
Thanks,
Bookmarks