I am surprised why wasn't the same working last night on my personal
Laptop. Could there be any special feature required to be turned on in this
regard???

Furthermore,

Any idea, how to have wildcards be used while being in cells. In other words
how to use =VLOOKUP(C1,A:A,1,FALSE) with C1="da??sh"

--
Do check "Yes" if this post is helpful,
Best Regards,

Faraz


"Shane Devenshire" wrote:

Hi,

You've given us the solution you are asking for. What's wrong with the
results your formulas are returning now?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Faraz A. Qureshi" wrote:

Any idea/suggestion/advice/UDF to return the first matching entry while using
VLOOKUP on basis of partial entry/wildcards.

An example in this regard is "Column A" containing entries like:
Faraz
Hakim
Saleem
Zeeshan
Rayomond
Jacob
Isaac
Adnan
Sajjad
Danish

then

=VLOOKUP("jaco*",A:A,1,0) returning Jacob
=VLOOKUP("*ara*",A:A,1,0) returning Faraz
=VLOOKUP("da??sh*",A:A,1,0) returning Danish

I sure am in a need of such a resulting function/combinations of
different/UDF and sure would oblige help in this regard.

Thanx, Thanx and Thanx in advance to you all!!!

--
Best Regards,

Faraz