Why is it that ~ is not recognised when using vlookup/hlookup?

P

P Koh

I have a huge spreadsheet with many ~ in many cells. Because of "~", I could
not use vlookup, hlookup or any search function.

Can anyone help?

Thank you.
 
M

Mike H

To Vlookup a Tilde use:-

=VLOOKUP("~~",A1:B10,2,FALSE)

Would find a single Tilde (~) without quotes.

Mike
 
B

Bob Phillips

see response in other thread in excel.misc

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top