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.
Help Article Resources
Check out the Formula Handbook template!