Vlookup of Child tasks

Hello,

I have a sheet with Unique parent tasks. The Child task however or not unique and repeat within each different Parent Task.

Example

(Parent Task) Job 10

Child Task 1 Paid

Child Task 2 not Paid


(Parent Task) 11

Child Task 1 Paid

Child Task 2 not Paid


What I need to do is retrieve data from a column in another sheet that has the same parent and child tasks from the original Sheet.


Vlookup2021-12-06_19-30-10.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!