title: Using VLOOKUP and not only match on first value
body: <p>I'm trying to use VLOOKUP to match activities with product codes, but run into an issue since VLOOKUP always returns the first match. I did a mockup below to describe my issue. To the left, I have a table with activity names and product codes.</p>
  <p>To the right, in column G, I want to, based on matching activity names in column F with activity names in column A, assign the activities product codes from column B.</p>
  <p><a href="https://i.stack.imgur.com/ex8MO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ex8MO.png" alt="enter image description here" /></a></p>
  <p>When I use VLOOKUP, it only matches with the first activity name and give all the activities with the same name the same product codes. I need them to get different product codes even if they have the same name. I want my function to &quot;take the next one&quot; on the list, when the first one is taken.</p>
  <p>Should I try to use another function to solve this? Is it impossible with VLOOKUP? My 'real' document has like 2000 rows, and the solutions I found on Youtube was not good to scale.</p>
  <p>Thanks in advance. I'm new to here so if I should clarify my question in any way, feel free to tell me.</p>