Lookup??

[Barbara]

I want to create a formula in a spreadsheet that will return the
correct salary. Here's how I need it to work: There are 16 steps in
the salary scale and 5 levels at each step (I want to create an area
that has the 16 steps going down in rows and the 5 levels going across
in columns with the corresponding salary at the intersecting cell).
Then, I want to have the employee name in one cell, step in the next
cell one cell and level in the next cell and have the salary returned.

I tried a lookup table but it doesn't seem to work. Any suggestions
would be appreciated.

 

[Domenic]

Assumptions...

1) A2:A17 contains your 16 steps
2) B1:F1 contains your 5 levels
3) B2:F17 contains your table
4) A20 contains the employee name
5) B20 contains the step of interest
6) C20 contains level of interest

Formula...

D20:

=INDEX($B$2:$F$17,MATCH(B20,$A$2:$A$17,0),MATCH(C20,$B$1:$F$1,0))

Also, if you want, you could continue to list each employee down the
column, along with their steps and levels, and copy the formula down the
column.

Hope this helps!

 

[Barbara]

Assumptions...

1) A2:A17 contains your 16 steps
2) B1:F1 contains your 5 levels
3) B2:F17 contains your table
4) A20 contains the employee name
5) B20 contains the step of interest
6) C20 contains level of interest

Formula...

D20:

=INDEX($B$2:$F$17,MATCH(B20,$A$2:$A$17,0),MATCH(C20,$B$1:$F$1,0))

Also, if you want, you could continue to list each employee down the
column, along with their steps and levels, and copy the formula down the
column.

Hope this helps!

Thanks so much. Your solution worked like a charm!

Barbara