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
- 65.5K Get Help
- 422 Global Discussions
- 143 Industry Talk
- 482 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!