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