Dependency Data Validation help!!

[Anna123Del]

Hello, I’ve been asked to create an employee performance review spreadsheet with drop down lists, each employee will receive a percentage of their pay as a bonus. Every employee is in one of three incentive categories (let’s say these are called high, medium and low) and for each rating (let’s say these are Excellent, Good, Average and Poor) they have a different % range. So basically if someone was in the High category and got a Good rating the manager would have 6-8 (%) to choose from on the drop down but if they were on the Low category they might have 0-4(%) to choose from.

So far I can get it doing the first two stages, choosing a drop down based on their rating but I need to add in a stage for their incentive category (high, medium, low) I’ve done this so far by converting the data to tables and giving them table names.. then doing Data Validation to pick up the table name and using INDIRECT.

Any suggestions very much appreciated!