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!!
Thanks,
rrenis