I want to use LOOKUP to make different combinations of existing cell contents instead of giving the specific values in the formula.
For example, a normal LOOKUP would be:
=LOOKUP(A2,{0,60,70,80,90},{"F","D","C","B","A"})
in which case if A2 had the value 70 in it, it would display C in the cell.
I want to replace the {"F","D","C","B","A"} with cell references, so that depending on the value of A2, LOOKUP will return the value of a certain cell reference.
Here it is WRONG, but it will help explain my question:
=LOOKUP(A2,{6,7,8,9},{A10&A11,A12&A13,A14&A15,A16&A17})
So, if the value in A2 is 6, LOOKUP displays the values of A10&A11 together in the cell.
Its the {A10&A11,A12&A13,A14&A15,A16&A17} portion I'm doing wrong, I think I need some quotes, single quotes or = before each one or something but I can't figure it out.
For example, a normal LOOKUP would be:
=LOOKUP(A2,{0,60,70,80,90},{"F","D","C","B","A"})
in which case if A2 had the value 70 in it, it would display C in the cell.
I want to replace the {"F","D","C","B","A"} with cell references, so that depending on the value of A2, LOOKUP will return the value of a certain cell reference.
Here it is WRONG, but it will help explain my question:
=LOOKUP(A2,{6,7,8,9},{A10&A11,A12&A13,A14&A15,A16&A17})
So, if the value in A2 is 6, LOOKUP displays the values of A10&A11 together in the cell.
Its the {A10&A11,A12&A13,A14&A15,A16&A17} portion I'm doing wrong, I think I need some quotes, single quotes or = before each one or something but I can't figure it out.
