VLOOKUP on partial lookup_value

F

Faraz A. Qureshi

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!!!
 
F

Faraz A. Qureshi

Hey!!!

You are right!!!

But 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???
 
F

Faraz A. Qureshi

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!!!
 
S

Shane Devenshire

Hi,

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

Faraz A. Qureshi

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"
 
J

Jacob Skaria

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

Faraz A. Qureshi

None's working.

--
Best Regards,

Faraz


Jacob Skaria said:
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)
Click to expand...
 
Top