parent child vlookup

Bobby1

Is there a way to use a sheet that has parent-child as a Vlookup for another page?

Genevieve P.

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

Bobby1

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

Genevieve P.

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