Help With Index Match / Collect
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.