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.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide more details? Which one is the reference column? What data are you trying to pull? Where are you trying to pull it to? What logic are you using to pull it?

  • Hollie Green
    Hollie Green ✭✭✭✭✭

    If the Parent column is unique you could use the below. If your data is fake you would just need to replace with the data that matches from your real data.

    =INDEX(COLLECT([27/03/23]:[27/03/23],Parent:Parent,"Parent1 Child3")

    =INDEX(COLLECT([03/04/23]:[03/04/23],Parent;Parent,"SMGB Toowoomba North Giftbox")