Using Vlookup to find pay rate for employees

Jhmtaylor

New Member
Joined
Oct 1, 2006
Messages
10
Our company operates in 2 countries with different rates of pay for personnel in each.

Part of my spreadsheet requires the looking up of pay rate based on the employees occupation and the country. I have been try to do this with Vlookup but I am beginning to believe this is not the correct function. The spreadsheet contains a cell with the employees countryand I would like to use value in this field to determine which pay scale to use.

Suggestions would be sincerely appreciated
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

jaya

Board Regular
Joined
Aug 18, 2004
Messages
225
In theory, you should be able to use Vlookup for this. Can you post a part of your worksheet?
 

Jhmtaylor

New Member
Joined
Oct 1, 2006
Messages
10
Sorry about this. How do I post the data and retain the formatting?

Employee Occupation Country Annual salary
A Look up Table
B Pay Scale
C
Australia China
Labourer 28,000 2,000
Clerk 32000 2,500
Junior Manager 40,000 4,000
Senior Manager 75,000 12,000
Director 120,000 40,000
 

jaya

Board Regular
Joined
Aug 18, 2004
Messages
225
Do you have the employee category in Column A and the corresponding slaray scales for Australia and China in columns B & C respectively?

Where do you want the results to appear?

Do you have a seperate list of employees with their occupations and country?
 

Jhmtaylor

New Member
Joined
Oct 1, 2006
Messages
10

ADVERTISEMENT

Column A Starting at A3 is for the employee names
Column B Starting B3 is a validation data list for the respective occupations
Column C stating C3 is the employees country (validation data list)
Columns G3 to I8 contain the occupation label and the two pay scales
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
Looks like Index/Match
Book1
ABCDEFG
1EmpPayOccupationCountry
2AustraliaChinaA2500ClerkChina
3Labourer280002000B120000DirectorAustralia
4Clerk320002500C2000LabourerChina
5Junior Manager400004000
6Senior Manager7500012000
7Director12000040000
Sheet1
 

Jhmtaylor

New Member
Joined
Oct 1, 2006
Messages
10
Thanks for that. Index match does not mean much to me (yet) I have only just learnt VLOOKUP but I will study it and trial it over the next few days. But what you have done looks right. Thanks again
 

Forum statistics

Threads
1,136,990
Messages
5,678,983
Members
419,797
Latest member
ikethegenius

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top