Lookup not returning data due to "~"

Hi Carim,

I have no idea what that means (though I am guessing CHAR(163) means character and relates to ~)

How would I pur S&PCOMP(RI)~£ in using CHAR(163)

Thanks!

Hi,

The Hlookup I am using is

=HLOOKUP(A266,'J:\PMA UK New\Performa\Dynamic Data\Indices\[DataStream Download.xls]Sheet1'!$5:$11,3,FALSE)

Where A266 is the cell reference for S&PCOMP(RI)~£

I'll attach the files in a bit via a zip file, I am just waiting to IT to put win zip on my computer.

Thanks!!

Its a mystery to me, if the list is sorted ascending the lookup function works for the values, but if an exact match is required it fails. I have no idea why but it must be the character highlighed

Regards

Dav