Vlookup or VBA solution

[Udara Chathuranga]

Hi all Excel Ninjas

Wanted help!

 

[Sam Mathai Chacko]

What is your lookup table? If all the products are unique in the sub-table (look-up table), which is in $C$2:$D$12, you can use

C15=VLOOKUP($B15,$C$2:$D$12,2,0)

 

[bobhc]

Udara Chathuranga

Exact category against what? Client or Product

 

[Udara Chathuranga]

Hi Sam

Thanks for the reply.

Products are not unique. There may be either
Ex:"Y-lease" or "Y*-lease" etc.

But I want to view the exact matching category in front of. (D2 to D11)

 

[Udara Chathuranga]

Hi bobhc

Exact category against the products in the range C2 to C11.

Thanks

 

[Sam Mathai Chacko]

When you say exact matching, does that mean you will have "Y-lease" and "Y*-lease" both listed in the sub-table? Can you post a workbook, with the expected output.

 

[Udara Chathuranga]

Sam

I am sorry. If Y-lease or Y*-lease may be only in the top table or actual data, Can I get an expected result? Whether I am going to not include extra Y*-lease to the sub table.

Thanks

 

[Sam Mathai Chacko]

Can you confirm that only the asterisk (*) will be the extra character in your lookup table? Will everything else be exactly the same?

 

[Udara Chathuranga]

Sam

There will be another characters. It can be changed.

Thanks

 

[Udara Chathuranga]

Sam

There will be mostly (*), ('), (-), ("). Imagine only including these characters and have a try.

Thanks and Best Regards
Udara

PS. Looking forward any fresh ideas.