Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup lookup_value text | Excel Worksheet Functions | |||
vlookup lookup_value | Excel Worksheet Functions | |||
Vlookup(lookup_value) | Excel Worksheet Functions | |||
VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) | Excel Worksheet Functions | |||
vlookup:same lookup_value, different returns | Excel Worksheet Functions |