MATCH and LOOKUP formula help

[ddub25]

Hello, can anyone help with a formula that would do the following:

IF find a match for K15 in range M14:T28, return value from corresponding row in column T

Thanks.

Dan

[Fotis1991]

Hi

Do you mean?

=INDEX(T1:T28,MATCH(K15;M14:S14,0))

[NBVC]

Fotis, you're mixing commas and semi-colons... which result in error message to the OP....

[ddub25]

I've adapted your formula to this but could not get it to work (and sorry I originally made a mistake asking to look in K15 when meant K16).

=INDEX(T14:T28,MATCH(M14:T28:K16,0))

It needs to match the value in K16 with a value that will be in M14:M28. If it finds a match, lets say in M14 it should return the value in T14

[Fotis1991]

ooops I did't noticed this....You know the problem....Semi-colons for me, comma for you...

=INDEX(T1:T28,MATCH(K15,M14:S14,0))


Edit:

=INDEX(T14:T28,MATCH(K16,M14:M28,0)) ???

[ddub25]

Thanks Fotis, I realised I can do it with a SUMIF instead anyway.

=SUMIF(M14:M28,K16,T14:T28)

Thanks for your help.

Dan

[Fotis1991]

You are welcome Dan

Have a nice weekend!