G
Guest
I am trying to make a formula that will look at two cells (K2 and L2) which
can have the following typed in them:
K2 can be "A, B, C, D, or E"
L2 can be "I, II, III, or IV"
I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2)
Based of of what is typed in the cells I want to look it up in the array.
Please help.
can have the following typed in them:
K2 can be "A, B, C, D, or E"
L2 can be "I, II, III, or IV"
I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2)
Based of of what is typed in the cells I want to look it up in the array.
Please help.