Try putting this in A1:
asdf?asdf

Then in C1:C2
asdfqasdf
asdf?asdf
and in D1:D2
333
444

Then in B1:
=vlookup(a1,c:d,2,false)

I would expect you to get 333 instead of 444 that I would want.


KL wrote:

I tried it on my spreadsheet and it looks like, for some reason, ? needs no
special treatment in VLOOKUP, but ~ and * do.

KL

--
Saludos,
KL
(XL 97, 2000, 2002)
------------
Ojo - mi separador de argumentos en las formulas es la coma ",".
Puede q necesites cambiarla por punto y coma ";".

Para usar mi direccion de correo electronico privada
borra "NOSPAM" y "PLEASE" antes de usarla.
------------
"Dave Peterson" wrote in message
...
One way is to have your =vlookup() fix any wild card characters (* and ?)
and
the character that's used to indicate that it shouldn't be treated like a
wild
card (~):

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

===
And yep, what you wrote is correct.

TWC wrote:

The "~" symbol should be proceeded by "~" in the function, for example if
I
was looking for "123~" or "123?", etc., I would list this as "123~~" or
"123~?" in my function.

"TWC" wrote:

I am using the "vlookup" function and it does not recognize the "~"
tilde
symbol in the data I'm looking up. How do I get Excel to recognize the
symbol?

--

Dave Peterson

--

Dave Peterson