wildcards with vlookup

  • Thread starter Thread starter skc
  • Start date Start date
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.
 
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
 
Back
Top