Need to import the Yes/No result from one sheet into another sheet
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!
Answers
-
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.
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
-
That might be hard, there is lots of private data, and those sheets are huge (Not my doing...)
-
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)
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training
Help Article Resources
Categories
Check out the Formula Handbook template!