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
|