Hi Forum,
First time poster and I am hoping to get some guidance and advice with the salary tool we are creating. It's all still very basic, but this formula would help us automate the role selection and salary matching.
The spreadsheet currently holds two TABS, 1) is the Salary overview and 2) is the job catalog.
The Jobcatalog has 5 coloms (A - E) which are:
- A: Role (containing the job title)
- B: Min (minimum salary associated with that job title)
- C: 90% of max (90% of the salary associated with that job title)
- D: 95% of max (95% of the salary associated with that job title)
- E: Max (max salary associated with that job title)
The Salary overview contains the following cells:
Cel B3: dropdown list referencing job titles in Tab 2 Colom A
Cel B8: dropdown list referencing salary range Titels in Tab 2 Colom B,C,D,E
Cel B11: this would be the cell which will contain the MATCH and INDEX formula we need help with so it will show a value based on previous mentioned criterea.
Purpose, to clarify, is that we can select a job title and salary range in B3 and B8 Tab 1 which will then auto populate B11 based on the Matches between B5, B8 TAB 1 and the INDEX in TAB 2.
Hopefully this is a clear story, I tried to add the spreadsheet, but somehow it is not allowing me to do so.
Attachment 783266
Thank you!
Bookmarks