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

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.