you say yo linked the 2 files ? how? the typical way to doe a "Vlookup" is to join the 2 files on the product code - but in your case you would pivot the excel file first then complete the join Pivot Data from Columns to Rows - Tableau
BTW other posters find this useful Anonymize your Tableau Package Data for Sharing in sharing their data
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.