Cross Sheet Formula help

I have a sheet that has Employee information including a location code and job title. I have another sheet where I want to use a cross sheet formula to get the employees name when matched with the location code and a job title. So in other words i need a formula that will look at the location code on my sheet and using that location code I want to search the other sheet for the word "manager" and the location code from the first sheet and then that would bring in the employees name.
Best Answer
-
See below general formula setup. You would need to create the cross sheet references (Bolded areas below).
Replace "Area Manager" with another job title you are looking to check up (in your case depending on your column, you would replace it accordingly).
=INDEX(COLLECT({Employee Info - Employee Name},{Employee Info - Location Code},[Location Code]@row, {Employee Info - Job Title},"Area Manager"),1)
Answers
-
See below general formula setup. You would need to create the cross sheet references (Bolded areas below).
Replace "Area Manager" with another job title you are looking to check up (in your case depending on your column, you would replace it accordingly).
=INDEX(COLLECT({Employee Info - Employee Name},{Employee Info - Location Code},[Location Code]@row, {Employee Info - Job Title},"Area Manager"),1)
-
@Leibel S Thank you that worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!