Need to import the Yes/No result from one sheet into another sheet

Andre O · 2024-01-09T17:56:35+00:00

There was an error rendering this rich post.

Hey, I'm trying to return the Yes/No value from one sheet based on an employees name into another sheet, and I'm struggling.

In the sheet A I created a new column called Eligible to Drive?

In Sheet B we have a drop down that has a Yes/No dropdown to answer that question.

How do I get the Yes/No answer imported to Sheet A based on the persons name in the Driver column??

Thanks!

Find more posts tagged with

Formulas

Accepted answers

All comments

AravindGP

Hi @Andre O

You can use the formula below as an example. You will need to create the reference to the other sheet by clicking on the reference another sheet link as shown in the screenshot

=INDEX({Eligibility to Drive Company Vehicle column reference}, MATCH([Employee name column in Sheet B]@row, {Employee name in Sheet A column reference}, 0)

Andre O

That might be hard, there is lots of private data, and those sheets are huge (Not my doing...)

Marlana K.

Depending on columns and data you could possibly use and Index match. If you provide me with a screenshot of all columns in both sheets I could assist you with writing the formula.

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.