Excel: Creating a formula using multiple sheets

I need to calculate salary increases. I have the main spreadsheet and I have 4 salary tables in separate sheets. I need the formula to look at the Grade the person is paid at (bachelors level, masters level, etc) first to know which sheet to use, then the years of experience column to know what line then the salary is equal to those years of experience.

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 02, 2015.

For more resources for Microsoft Excel