Lookup not returning data due to "~"

Originally Posted by dgo

Hi,

I've got a spreadsheet that has a Hlookup into a different spreadsheet. It is looking up codes such as MSPACF(RI) and these work fine and it is returning data associated with these codes

The problem comes when I look up the code S&PCOMP(RI)~£ I have 4 codes that all end in ~£ and for each of these the lookup is returning N/A.

Is there anyway to get this work? It's driving me mad!!!

Many thanks
Dom.

Hi,

perhaps

If range_lookup is FALSE and lookup_value is text, then you can use the wildcard characters, question mark (?) and asterisk (*), in lookup_value. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) preceding the character

from
http://office.microsoft.com/en-us/ex...093351033.aspx

will explain?


=VLOOKUP("A~~A",A1:A3,1,FALSE)

finds A~A

---