parent child vlookup
Is there a way to use a sheet that has parent-child as a Vlookup for another page?
Answers
-
Hi @Bobby1
Would you be able to explain what you want the destination sheet to look like, or what you already have set up?
You could use a Report to pull rows from this current sheet, and filter by if the column says "Parent" or not.
However if you have another sheet set up already with the values in your "Rows" column, then you could use an INDEX(COLLECT formula to pull back the data from a different column if the Rows matched one value and if your other column said "Parent".
Here's an example of that type of formula: Can you use 2 match criterias in an index/match formula?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
hi @Genevieve P. sorry I should have clarified.
Im looking to have Vendor Admin Name (Parent) automatically be populated when a any of the Vendors (Child) is present. Parent/Child will be on a separate sheet (A) as Vlook up and the other sheet (B)will reference the vlookup sheet
-
Hi @Bobby1
Thank you for clarifying!
In this instance you will need to have a helper column in your main source sheet that brings the parent name into each child row with the PARENT Function. For example you can set up a column called "Parent Name" and then use the following formula:
=PARENT(Rows@row)
Then you can use an INDEX(MATCH formula to match the Task Name across sheets and bring back data from that Parent Name column.
=INDEX({Parent Name Column}, MATCH(Vendor@row, {Rows Column}, 0))
See: Formula combinations for cross sheet references
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!