Pulling information from second sheet based off one criteria and and if it falls between two numbers
I have one sheet that has job title, salary and then a column called Thirds location where I want to pull in information from another sheet and have it say lower third, middle third or upper third. On the other sheet I have the salary ranges and then broken into thirds. For example, For sally Gold, I want to reference the other sheet and have it identify the job title is coordinator and inbetween 60,000 and 63,333 so it would return "lower third"
Help Article Resources
Check out the Formula Handbook template!