Index Match function for children rows on two sheets
Hi there,
I am trying to index match on data in the second level children rows from Sheet 1 to second level children rows on Sheet 2, and am getting this error messages. Screenshots are at the end.
Screenshots:
Sheet 1 (data reference sheet)
Sheet 2 (pulling data from source source sheet into this sheet)
If I try to use the usual formula in Sheet 2 I get: "#NO MATCH"
=INDEX({Sheet 1 Start Date}, MATCH(ID@row, {Sheet 1 ID}, 0))
If I try to use "CHILDREN" in the formula in Sheet 2 I get: "#UNSUPPORTED CROSS-SHEET FORMULA"
=INDEX(CHILDREN({Sheet 1 Start Date}), MATCH(CHILDREN(ID@row), CHILDREN({SHEET 1 ID ID}), 0))
Is there a way to make this work? I saw some discussion columns, but I can't seem to find a solution.
Thank you!
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!