Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Function | Excel Discussion (Misc queries) | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions |