S
skc
Does anyone know if there is a way to use wildcards with vlookup
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aladin Akyurek
You need to specify a tad more...
=VLOOKUP("*"&A1&"*",Table,3,0)
=VLOOKUP(A1&"*",Table,3,0)
=VLOOKUP("*"&A1,Table,3,0)
would be examples of using wildcards.
=VLOOKUP("*"&A1&"*",Table,3,0)
=VLOOKUP(A1&"*",Table,3,0)
=VLOOKUP("*"&A1,Table,3,0)
would be examples of using wildcards.
M
Mark Graesser
Aladin
I didn't think you could do that. Guess I should have tested it first. Thanks for the info, this will be very useful
Regards
Mark Graesse
[email protected]
----- Aladin Akyurek wrote: ----
You need to specify a tad more..
=VLOOKUP("*"&A1&"*",Table,3,0
=VLOOKUP(A1&"*",Table,3,0
=VLOOKUP("*"&A1,Table,3,0
would be examples of using wildcards
I didn't think you could do that. Guess I should have tested it first. Thanks for the info, this will be very useful
Regards
Mark Graesse
[email protected]
----- Aladin Akyurek wrote: ----
You need to specify a tad more..
=VLOOKUP("*"&A1&"*",Table,3,0
=VLOOKUP(A1&"*",Table,3,0
=VLOOKUP("*"&A1,Table,3,0
would be examples of using wildcards
H
Harlan Grove
...I didn't think you could do that. . . .
Note that it only works when the 4th argument to VLOOKUP is FALSE/0.