Lookup formula

  • Thread starter Thread starter Damien
  • Start date Start date
D

Damien

I am currently working on a formula which I am having
trouble with. It is in relation to a payroll report. I
have an employee number on an intial worksheet. I need to
create a formula to match the employee number with a
different worksheet which will give a pay class, I then
need to match that pay class to a new worksheet which will
give an hourly rate.

If anyone knows the best way about creating a formula for
this your help would be much appreciated.

Cheers
 
Hi,

Say you have the salary bracket data in range b2:d7 of
sheet 2. The range is named sal. In column B you have the
emp no and in column D is the salary range. Likewise, the
hourly rate data is in range b2:d7 of sheet 3. The range
is called hourly. In column B you have the salary bracket
and in column D is the hourly rate.

We want the result to be returned in sheet 1. The emp nos
are mentioned in column B. Therefore for an emp no
entered in cell B5, enter the following formula in cell D5

VLOOKUP(VLOOKUP(B5,sal,3,FALSE),hourly,3,FALSE)

Kindly feel free to contact me on my personal id -
(e-mail address removed)

Regards,

Ashish Mathur
Excel - MVP
 
Back
Top