Using Vlookup to find pay rate for employees

Jhmtaylor

New Member
Joined
Oct 1, 2006
Messages
12
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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
In theory, you should be able to use Vlookup for this. Can you post a part of your worksheet?
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
Looks like Index/Match
Book1
ABCDEFG
1EmpPayOccupationCountry
2AustraliaChinaA2500ClerkChina
3Labourer280002000B120000DirectorAustralia
4Clerk320002500C2000LabourerChina
5Junior Manager400004000
6Senior Manager7500012000
7Director12000040000
Sheet1
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,214,262
Messages
6,118,549
Members
448,835
Latest member
Profast123

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
Back
Top