INDEX MATCH Formula

[japj1984]

Hi,

This INDEX MATCH Formula is returning back an amount that is not listed in Col I.

Formula: =INDEX(B3:B40,MATCH(I4,I$4:I$27,0))

[Khalidngo]

Hi,
I think you need to check both array sizes of INDEX and MATCH, it should be equal i.e. either 40 or 27 in both.

Regards,

[japj1984]

Hi,
I think you need to check both array sizes of INDEX and MATCH, it should be equal i.e. either 40 or 27 in both.

Regards,

I changed the array size but it is still returning the same result.

[Khalidngo]

Perhaps you've missed locking your range by using $:
=INDEX($B$4:$B$40,MATCH(I4,I$4:I$40,0))

But I have not understood the logic of your formula