If/cross referencing functions

[Darren_Preston]

Hi,
I have a workbook for working out rates of pay for staff based on scales of
pay and hours worked.
I'm trying to get the supervisors to complete the hours and excel to go find
the scale, lookup the hours and report the relevant pay.
At the moment I'm trying to use one sheet for data entry and a 7 column (1
for hours worked and 6 for scales) x 25 row (we pay differing amounts for
every 1/4 hour worked!) table for the lookup - and it's not proving easy.
Help

Darren

[Biff]

You need to provide more details.

Biff

"Darren_Preston" <Darren_Preston@discussions.microsoft.com> wrote in message
news:81CD75F4-5420-4A65-B01B-EC28BBCD09C3@microsoft.com...
> Hi,
> I have a workbook for working out rates of pay for staff based on scales
> of
> pay and hours worked.
> I'm trying to get the supervisors to complete the hours and excel to go
> find
> the scale, lookup the hours and report the relevant pay.
> At the moment I'm trying to use one sheet for data entry and a 7 column (1
> for hours worked and 6 for scales) x 25 row (we pay differing amounts for
> every 1/4 hour worked!) table for the lookup - and it's not proving easy.
> Help
>
> Darren
>