Vlookup to find result in child row


Hi all

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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!