Escape it with another ~, like

=VLOOKUP("~~",K1:N9,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TWC" wrote in message
...
I am using the "vlookup" function and it does not recognize the "~" tilde
symbol in the data I'm looking up. How do I get Excel to recognize the
symbol?