# VLOOKUP (I Think?) Application

#### MntnrMark

##### Board Regular
I have several worksheets within a file. Each of the respective worksheets (minus one - the "master", described below . . . please overlook the politically incorrect use of that terminology; I didn't select it) is a monthly summary of hours worked on individual calendar days by several individual employees. Each employee's time is grouped together in rows (see the screenshot below for an example. It stops at Row 19 in the screenshot below, but goes on for hundreds of rows in the real file).

On the "master" worksheet (the first worksheet in the file, named "Rates") are a list of names, their respective work positions, and the hourly rate for their respective positions (see the screenshot below).

The list of names and rates goes on for several hundred rows too.

What I need to do is look up names on the "master" and fill in their specific rates on each of the monthly worksheets (i.e., Column D's in the above screenshot). In the above example, Cell D2 would show \$65 an hour, Cell D8 would show \$70 an hour, etc., as listed on the "master" by association with the individual person.

I think this is a VLOOKUP candidate. I'm thinking I'd put a VLOOKUP formula in Cell D2, search for the individual name on the "master" to find a person's rate and then display it. Then (hopefully) by copying the formula in D2 downward for the several hundred rows in each monthly worksheet I could then show very person's rate from the master.

I've tried to figure this out on my own but I'm stumped. Any help would be very much appreciated.

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### alansidman

##### Well-known Member
=vlookup(A2,Rates!A2:Cx,3,False) where x is the last row in the Rates Sheet

#### MntnrMark

##### Board Regular
=vlookup(A2,Rates!A2:Cx,3,False) where x is the last row in the Rates Sheet

Thanks. Which A2 - the ones on the Rates sheet or the one on each of the monthly worksheets?

#### MntnrMark

##### Board Regular
Never mind - I figured it out. THANKS, ALANSIDMAN ! ! !

#### MntnrMark

##### Board Regular
=vlookup(A2,Rates!A2:Cx,3,False) where x is the last row in the Rates Sheet
Oh, one more thing. What would I need to change in the VLOOKUP formula to display the work Position for each employee?

#### alansidman

##### Well-known Member
Change the formula to =vlookup(A2,Rates!A2:Cx,2,False)

This changes the column you are looking for from 3rd to 2nd column in the lookup range.

Replies
1
Views
90
Replies
11
Views
121
Replies
1
Views
95
Replies
0
Views
377
Replies
14
Views
476

1,181,687
Messages
5,931,442
Members
436,790
Latest member
aelbaitam

### 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