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