Hi Excel Forum Experts,
Can you please assist me, I'm trying to match the unique product code with the text describing the product.
A1:C86 is the format of a stock on hand sheet, you can see how the Varietal, vintage and brand of the wine are in different cells.
G1:G16 are cells that I have copied from another program. The objective is to match the product code in column A with the text in column G and insert the unique product code into say column F.
I've tried VLOOKUP, Index/Match but they return incorrect values or errors.
Thanks in advance for any help and this is the first question I've posted on this forum, so apologies for any mistakes.
Scott
Bookmarks