still require help with lookup/match formula - please.
Posted by Frank Johnson on January 14, 2002 6:53 AM
Basically I have two sets of data, the first has three columns:- (A)=Name (B)=Date Worked (C)=Current Hourly Pay Rate.
I append columns (A) & (B) to a worksheet and then require a formula in column (C)that will look up the hourly payrate from a seperate table of data.
The second table is a history of all pay rates and is (D) =Name (E)=Date hourly rate came into effect (F)= Hourly payrate. This second table of data
lists all names and the pay rate history for each individual along with the date the pay rate changed. The formula firstly has to match name (column A to D) then
using column (B) decide which pay rate, from column (F),was in effect on the date the individual worked.