VLOOKUP returns #N/A when searching for the ~ symbol.

Hi
search for
~~

--
Regards
Frank Kabel
Frankfurt, Germany
"AE1245" schrieb im Newsbeitrag
...
VLOOKUP returns #N/A when searching for the ~ symbol.

=VLOOKUP("~~",---,---,---)

HTH
Jason
Atlanta, GA

-----Original Message-----
VLOOKUP returns #N/A when searching for the ~ symbol.
.

And you may not get the answer you want when your data has asterisks or question
marks, too.

=VLOOKUP(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"~"," ~~"),"?","~?"),"*","~*"),
Sheet2!$A:$B,2,FALSE)

would be one way to avoid all three problems.

AE1245 wrote:

VLOOKUP returns #N/A when searching for the ~ symbol.

--

Dave Peterson