Help With Index Match / Collect
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
-
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?
-
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")
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives