None's working.

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

Faraz

Fine. That happens once in a while.

With da??sh in B1 both the below formulas should work..

=VLOOKUP(B1,A:A,1,FALSE)
=VLOOKUP("*" & B1&"*",A:A,1,FALSE)
--
If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

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"

Thanx again man!!!

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

Faraz

Your formula really does return the first entry for all the examples
provided, right?

=VLOOKUP("da??sh",A:A,1,FALSE)

If this post helps click Yes
---------------
Jacob Skaria


"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