Index,Match problem...

[kmc500]

Hi.

I am using Index, Match function twice in the same spreadsheet. Each function accesses an array in different 'sheet'.

i.e.
1)
=INDEX('Linear Cal Data OK'!C8:C6925,MATCH(AN3,'Linear Cal Data OK'!B8:B6925))

and

2)
=INDEX('MMF Cal Data'!C19:C3931,MATCH(AP3,'MMF Cal Data'!B19:B3931))

For some reason, the 1) formula works correctly, 2) does not.

Evaluating the function in excel shows it is following the correct principles, accessing the correct arrays -
but the result delivered form formula 2) is always from B3931, B3932, etc

Any ideas?

Thanks

KMC500

[Teethless mama]

Post your workbook

[Pepe Le Mokko]

Perhaps add the last element in the MATCH function, 0,1 or -1 (match_type)

[Kevin UK]

Here you go!!

Post your workbook