index and match function

[Gusher]

'=INDEX(range10,MATCH($B5,banklist10,0),MATCH(K4,header10,0))


This formula returns data but it is the cell one column to the left of the data it should return. Any thoughts please?

 

[PeteWright]

You have named tables and did no tell us where they are.
range10, banklist10 and header10
Could you please post a screenshot or the reference of your tables.

 

[Gusher]

=INDEX(range10,MATCH($B5,banklist10,0),MATCH(K4,header10,0))


This formula returns data but it is the cell one column to the left of the data it should return. Any thoughts please?

range10 = data2!$D$5:$AN$3880

banklist10 = =data2!$B$5:$B$3880

header10 = =data2!$C$3:$AN$3

 

[etaf]

the ranges seem wrong

so the header is C and so the Range 10 - should start at C OR header start at D

header should be
=data2!$D$3:$AN$3

 

[Peter_SSs]

@Gusher

I have merged your two threads asking the same question.

In future, please do not post the same question multiple times. See Forum Rules (#12).
If asked for additional information, please post that additional information in the same thread.