ExcelBanter - VLOOKUP ~ symbol

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP ~ symbol (https://www.excelbanter.com/excel-worksheet-functions/8151-vlookup-%7E-symbol.html)

AE1245

VLOOKUP ~ symbol

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

Frank Kabel

Hi
search for
~~

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

Jason Morin

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

HTH
Jason
Atlanta, GA

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

Dave Peterson

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

All times are GMT +1. The time now is 04:57 AM.