Using the Index Function

[emad1001]

Hello everyone,

I am attempting to use the index and match function in excel but it is giving me a problem. Here it is:

=IF(P23="U",INDEX($AB$3:$AF$3,R23,MATCH(S23,$AB$2:$AF$2,0))

The table that it refers to is as follows:

|9 10 11 12 13
------------------
U | 21 23 25 28 35
------------------

So when Someone enters in a "9" for cell S23, and a U for P23, it should give "21".

Any help would be appreciated.
Thanks

[oldchippy]

Hi,

Try this

=IF(P23="U",INDEX($AB$3:$AF$3,R23,MATCH(S23,$AB$2:$AF$2,0)))

[olasa]

It looks like this could work:
=IF(P23="U",HLOOKUP(S23,$AB$2:$AF$3,2,0),"")
//Ola

[oldchippy]

Nice one Ola - works for me too

[olasa]

Thanks :-)
//Ola

[daddylonglegs]

=IF(P23="U",INDEX($AB$3:$AF$3,R23,MATCH(S23,$AB$2:$AF$2,0))

What's the purpose of R23