G'day Colin

You can quite easily combined a dropdown list with and table array
The array can be on the same sheet or different if you like, the array in
this example is set @ A1 on an assumed sheet name "Lookups"

The example below assumes the following:

2 dropdowns, A1 = "Title" & B1 = "Grade"

The result: C1 =

=IF(A1="","",OFFSET(LookUp!$A$1,MATCH(A1,LookUp!$A $2:$A$20,0),MATCH(B1,LookUp!$B$1:$G$1,0)))

The array would look like this:


A B C D

1 Title/Grade 1 2 3
etc
2 Manager 100K 200K 300k etc
3 Slave 10K 11K 12K
etc

The main benefit of using an array is that you only have to update the
values in the array when seasonal salary adjustments occur and not the
values of individual cells in your main sheet.

You could even expand the dropdown "Grade" list and array as you like. eg 1L
= "Grade 1 Low" 1M = "Grade 1 Med".....etc

Your array will obviously change to suit also.

A B C D

1 Title/Grade 1L 1M 1H
etc
2 Manager 100K 200K 300k
etc
3 Slave 10K 11K 12K
etc

HTH
Regards
Mark.