Help With Index Match / Collect

Options

Hi,


I'm having trouble pulling the data I need on some of my sheets. I'm trying to figure out how to use Index Match or Collect in this scenario, but can't get it to work.

Essentially, there's a reference column and then a row with I want it to reference and pull the data below. Image upload shows a base example.

I can't use a VLOOKUP in this scenario as the reference numbers in the row shift.


Any help would be amazing.


Answers