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

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.

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

To Vlookup a Tilde use:-

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

Would find a single Tilde (~) without quotes.

Mike

"P Koh" wrote:

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.

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

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)



"Mike H" wrote in message
...
To Vlookup a Tilde use:-

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

Would find a single Tilde (~) without quotes.

Mike

"P Koh" wrote:

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.