VLOOKUP with wild cards urgent!!

[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

 

[Niek Otten]

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

 

[Don Guillett]

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

 

[VENKAT]

change <true> to <false> and see whether you get it

==============

 

[Alan Beban]

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

???!

Alan Beban

 

[Niek Otten]

Sorry about that; a total miss

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel