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.

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.