VLOOKUP with only certain words

terp410

New Member
Joined
Jul 12, 2007
Messages
4
hi - I have two spreadsheets... and trying to use a VLOOKUP formula (Or something similar if there is better) to basically do the following:

- Spreadsheet A has a product name - say "Color Hair Care"
- Spreadsheet B has a more detailed product name and a UPC code (separate columns) - "Color Hair Care 10 ounces Twin Pack)
- I want to say "Color Hair Care" from Spreadsheet A on spreadsheet B and then pull in Column C value (UPC). However, the "Color Hair Care" may be in a longer form on Spreadsheet B - like "Color Hair Care 10 ounces twin pack".

So basically how do I use a VLOOKUP model by saying "contains these words", versus an exact match.

Does that make sense?

Thanks!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Thx not sure what I am doing wrong - when you say wildcard... is that the "*"? Or should i be putting words in the quotes?
I uploaded a mocked example.
Tab 1 - I am trying to find the UPC (in yellow column C where I will input) by calling Column B to the VLOOKUP on tab 2. However the "product Name" is a little different on Tab 2, but most will contain phrases of it. Tab 2 product name is in Column A. UPC column 3.
Thoughts?
 
Upvote 0
You would use it exactly as I posted it with the "*"

Example

Excel Workbook
AB
2Color Hair Cared
Spreadsheet A
Excel Workbook
ABC
2blaha
3blahb
4blahc
5Color Hair Care 10 ounces Twin Packd
6blahe
7blahf
Spreadsheet B
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top