wildcards with vlookup

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.
 
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
(e-mail address removed)

----- 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated phrases wildcard? 1
How to count the numbers in a Word document? 0
Using FIND to highlight text (with dashes) 4
VLookup with wildcard 6
Help With VLOOKUP 2
Dynamically load DataValidation List through Source field? 1
Keep text matching a wildcard spec in replace/substitute 3
Search assistance 1

Top