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 GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!