PDA

View Full Version : Solved: Index Match Formula - Odd Behaviour



rrenis
05-28-2009, 03:47 AM
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

xld
05-28-2009, 04:11 AM
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
05-28-2009, 04:14 AM
Thanks xld - I've been pulling my hair out over this!! :bow:

Cheers,
rrenis.