Similar "Lookup problem"

[John Hubiak]

Perhaps this problem is similar to what a previous posting
by a gentleman named Gary had, but, here it goes:

I am attempting to do use a look-up table. I have two
entered values (L24 and L25), and I want to use the values
in those cells to locate a value in table K36 through M41
to obtain a value so that further calculations can be made
using that value. The table consists of headings in row
36 and data in the remaining cells. I was attempting,
unsuccessfully, to do the following, using nested IF's:

=IF(AND(L24=0, L25=0.5), "L38",
IF(AND(L24=0, L25=1.0), "L39",
IF(AND(L24=0, L25=2.0), "L40",
IF(AND(L24=0, L25=3.0), "L41",
IF(AND(L24=1, L25=0.5), "M38",
IF(AND(L24=1, L25=1.0), "M39",
IF(AND(L24=1, L25=2.0), "M40",
IF(AND(L24=1, L25=3.0), "M41", "A value is out of
range"))))))))

Why does this not work? I've tried various means of
parenthesis use, to no avail. I keep getting the screen
that indicates that that there is an error with my formula.

Help,
John

 

[Aladin Akyurek]

Double quotes around what is intended to be a cell ref, like M38, changes it
to a text bit, so making it loose its special meaning.

BTW, it looks like...

==IF(L24+1=1,INDEX(L38:M41,MATCH(L25,{0.5,1,2,3},0),L24+1),"Out Of Range")