Vlookup to find result in child row
I am after help on a formula to pull in information from another smartsheet using vlookup but at the child level.
I am looking for a match in my project to Ref, which is 699 and then find the data within the child row from Task 01. In this case, the result would be DC
The reason for this is that we need to create a report on who is responsible for the Task 01
Help Article Resources
Check out the Formula Handbook template!