VLOOKUP with wild cards urgent!!

  • Thread starter Thread starter J T
  • Start date Start date
J

J T

Lets say i have two sheets
Sheet1

Pradeep


Sheet 2
deep

in sheet2 i wrote the formula =VLOOKUP("*deep*",Sheet1!A:A,1,TRUE), i was
expecting Pradeep, but it gave me #N/A. How correct am i?

thanks
 
If you look in HELP for the specifications of VLOOKUP, you'll find nothing
about wildcards. They are not implemented.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
try this for the row
=MATCH("*deep*",Sheet1!A:A,0) for 1st instance
=MATCH("*deep*",Sheet1!A:A,-1) for last instance
use with index to find the actual word

=INDEX(Sheet1!A:A,MATCH("*deep*",Sheet1!A:A,0))
 
Back
Top