# Using Vlookup to find pay rate for employees

#### Jhmtaylor

##### New Member
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?

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

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?

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

Looks like Index/Match
Book1
ABCDEFG
1EmpPayOccupationCountry
2AustraliaChinaA2500ClerkChina
3Labourer280002000B120000DirectorAustralia
4Clerk320002500C2000LabourerChina
5Junior Manager400004000
6Senior Manager7500012000
7Director12000040000
Sheet1

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

Replies
4
Views
1K
Replies
0
Views
180
Replies
5
Views
263
Replies
1
Views
740
Replies
9
Views
587

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.

### Which adblocker are you using?

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

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