| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup problem
Vlookup requires exact lookup value, is it possible to do lookup if that
value is available within a particular cell? I want to do vlookup the value wherein lookup_value is available in particular cell but it is alongwith some other words i.e. i would like to search for a code "PLLU" but in a table array value is available as "PLLUPINT/PLLLINFE". Since the value is available as word contains, vlookup value is not possible. In other words i would like to search for a word which contains that value. How can i do such a vlookup either through excel or macro. Please suggest. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup problem
=VLOOKUP("*PLLU*",array,column#,0)
"Vijay Kotian" wrote: Vlookup requires exact lookup value, is it possible to do lookup if that value is available within a particular cell? I want to do vlookup the value wherein lookup_value is available in particular cell but it is alongwith some other words i.e. i would like to search for a code "PLLU" but in a table array value is available as "PLLUPINT/PLLLINFE". Since the value is available as word contains, vlookup value is not possible. In other words i would like to search for a word which contains that value. How can i do such a vlookup either through excel or macro. Please suggest. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP problem | Excel Discussion (Misc queries) | |||
| Vlookup Problem | Excel Worksheet Functions | |||
| VLOOKUP problem with using a - | Excel Worksheet Functions | |||
| VLOOKUP problem | Excel Worksheet Functions | |||
| vlookup problem | Excel Worksheet Functions | |||
Hybrid Mode
