parent child vlookup

Options

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


Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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
    Bobby1 ✭✭✭✭
    Options

    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.
    Genevieve P. Employee Admin
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!