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
=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