What is the best way to find pay rate

[asad]

Hello All,

I have the following table

Group	Date	Hourly Rate
ABC	1/07/2016	26.5
DEF	1/07/2016	26.5
GHI	1/07/2016	$20.11
JKL	1/07/2016	$20.11
MNO	1/07/2016	24.1285
PQR	1/07/2016	26.5
STU	1/07/2016	26.5
VWX	1/07/2016	26.5
YZA	1/07/2016	26.5
BCD	1/07/2016	26.5
EFG	1/07/2016	26.5
ABC	7/08/2016	26.8975
DEF	7/08/2016	26.8975
JKL	7/08/2016	20.1105
MNO	7/08/2016	24.13
PQR	7/08/2016	26.8975
STU	7/08/2016	26.8975
VWX	7/08/2016	26.8975
YZA	7/08/2016	26.8975
BCD	7/08/2016	26.8975
EFG	7/08/2016	26.8975

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Now I would like to find out the pay rate for a group for a date say 15/12/2016, which formula would I use? For example I want the pay rate for GHI that will be applicable on 15th December 2016. The answer should be 20.11 as there is only one pay rate for GHI and that is starting from 1/07/2016. But if I want to find out for BCD for 15/12/2016, it should give me 26.8975 and for the same group (BCD) for date 15/07/2016, the rate should be 26.5.

Thanks a lot.
Asad

 

[asad]

Don't worry. Worked it out. Thanks for trying though.