Solved: Index Match Formula - Odd Behaviour

[rrenis]

Hi all, I have a spreasheet (attached) with the following formula...

=INDEX(Data!$1:$1709,MATCH(Summary!$A9&"R",Data!$A:$A,0),MATCH(Summary!BZ$2,Data!$1:$1,0))

The formula is used to return data (that will be added to regularly) from a seperate sheet. It works fine, but strangely not for one particular reference - which I've highlighted in green on the Summary and the Data sheets to make it easier to identify.

It's driving me nuts so any help would be greatly appreciated!! :banghead:

Thanks,
rrenis

[Bob Phillips]

The problem my friend is that the Estimate Start value apperas twice in the data first row, so the match finds the first, column H, not the second, column R, and returns the corresponding blank data.

[rrenis]

Thanks xld - I've been pulling my hair out over this!! :bow:

Cheers,
rrenis.