Using ~ in VLookup function
 

Does anyone know if VLOOKUP will recognise a ~ symbol? My datasource
contains them, and I am not having any luck getting the function to
work

Thanks


--
Andyp95
------------------------------------------------------------------------
Andyp95's Profile: http://www.excelforum.com/member.php...o&userid=24708
View this thread: http://www.excelforum.com/showthread...hreadid=382736

Hi

Use two tildes, instead of one! Try "~~".

--
Andy.


"Andyp95" wrote in
message ...

Does anyone know if VLOOKUP will recognise a ~ symbol? My datasource
contains them, and I am not having any luck getting the function to
work

Thanks


--
Andyp95
------------------------------------------------------------------------
Andyp95's Profile:
http://www.excelforum.com/member.php...o&userid=24708
View this thread: http://www.excelforum.com/showthread...hreadid=382736

Thanks for the suggestion - still no joy . . . .


--
Andyp95
------------------------------------------------------------------------
Andyp95's Profile: http://www.excelforum.com/member.php...o&userid=24708
View this thread: http://www.excelforum.com/showthread...hreadid=382736

I'd try it again. Maybe something like this, too:

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

* and ? are wildcard characters.

The tilde tells excel to treat the asterisk as an asterisk and the question mark
as a question mark--not as wild cards.

To tell excel to treat this "escape character" as itself, you double it up.



Andyp95 wrote:

Thanks for the suggestion - still no joy . . . .

--
Andyp95
------------------------------------------------------------------------
Andyp95's Profile: http://www.excelforum.com/member.php...o&userid=24708
View this thread: http://www.excelforum.com/showthread...hreadid=382736

--

Dave Peterson