Salary codes

  • Thread starter Thread starter Warrickrick
  • Start date Start date
W

Warrickrick

I am trying to specify a numerical code the will produce a specific salary.
Example: 100=$33328, 101=$$34167, etc. I would like to input the code number
in one column and have the resulting salary put into the column to the right
of it.
 
Hi,
you have your list in sheet2 with code in column A and amount in B, then in
sheet1 you enter the code in cell A5 in B5 enter

=vlookup(A5,sheet2!A1:B1000,2,false)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import data from txt file to an existing excel file 1
If and Vlookup Query 6
Pivot Table Set Up 2
Salary data entry - circular reference a better way 9
Finding a valid cell in a row 1
sumproduct with multiple criteria in single column 4
Count Functions 4
staff salary expense database 0

Back
Top