If you want to find Hello~ World, do:

VLOOKUP("Hello~~ World",array,2,0)

Tilde is a wildcard search. double tilde negates the wildcard concept.

"Jerry W. Lewis" wrote:

What exactly do VLOOKUP and MATCH do with tildas (~) in text strings?

=VLOOKUP("Hello~ World",array,2,0)
will match "Hello World" but not "Hello~ World"

=MATCH("Hello~ World",array,0)
will not match either string.

I am using Excel 2003, and Help does not say anything about this for either
function.

Jerry