| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
