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