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!
- 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!