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

Andre O

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!

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.

Andre O

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

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)