VLookup, Index, and Match

B

bam

This is similar to another post -- any help would be appreciated

I have a table (Table A) containing rows containing names, time reporting
period, and hours worked
Joe Smith, 12/31/06, 32 hours
Sam Jones 1/7/07, 44 hours
Betty Smith 1/7/07, 52 hours
Joe Smith 1/7/07, 39 hours
Etc. (10,000 entries)

I have a second table (table B) that contains names and rates. Rates may
change for each person for specific reporting periods, so I have created a
second table that shows rate changes per time reporting period for the year.
12/31/06 1/7/07
Joe Smith $50 $45
Sam Jones $45 $45
Betty Smith $55 $60

I'd like to populate the rate in a cell ajacent to the cell in table A
containing the hours, so my spreadsheet would look like this...
Joe Smith, 12/31/06, 32 hours, $50
Betty Smith, 12/31/06,$55
Sam Jones 1/7/07, 44 hours, $45
Betty Smith 1/7/07, 52 hours,$60
Joe Smith 1/7/07, 39 hours, $45
Etc. (10,000 entries)

Thanks in advance for any help

BAM
 

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

using sumproduct with dates 3
How to get the array like this? 6
Mixed Data in column 5
Delete Duplicates except newsest Date 14
Dlookup 7
Number Match Formula? 7
Trying to recreate bootable CD from zipped files 14
Adding/subtracting time and displaying hours, minutes, seconds 2

Top