VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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???
--
Do check "Yes" if this post is helpful,
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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

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

VLOOKUP on partial lookup_value
 

OK!

Just found the error. I had placed Da??ish instead of Da??sh
--
Do check "Yes" if this post is helpful,
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