Vlookup to find result in child row

David Clunie

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

Paul Newcome

Ok. You are going to want something along the lines of...

=INDEX(COLLECT({Other Sheet Assigned To Column}, {Other Sheet Reference Number Column}, @cell = "699", {Other Sheet Project Column}, @cell = "Task 01"), 1)

Paul Newcome

Is "Task 01" repeated anywhere else within that column?

David Clunie

Hi,

Yes it will be repeated ,however the reference number would be unique along with build number .

Paul Newcome

Ok. You are going to want something along the lines of...

=INDEX(COLLECT({Other Sheet Assigned To Column}, {Other Sheet Reference Number Column}, @cell = "699", {Other Sheet Project Column}, @cell = "Task 01"), 1)