title: Excel formula to pull data from Column B, if Column A matches Column C when multiple rows will match
body: <p>I need some help with a formula to pull data from one sheet in Excel, to a database in another sheet. </p>
  
  <p>The raw data:</p>
  
  <p><img src="https://i.stack.imgur.com/5WdaI.jpg" alt="1"></p>
  
  <p>The final database:</p>
  
  <p><img src="https://i.stack.imgur.com/EBmG4.jpg" alt="2"></p>
  
  <p>As you can see from the images, the data list I'm searching for is all over the place. </p>
  
  <p>I want to pull it through to the final database, but my formula doesn't account for the fact that there are multiple rows with the values I'm searching for. Not all the listings have all the relevant information either, so the rows between them aren't constant. </p>
  
  <p>I've tried VLOOKUP, MATCH, IF, etc, and the formula in the image is the closest I've come to making it work. </p>
  
  <p>I can pull it through manually, but if there's a formula to make my life easier, I'd really appreciate it. </p>