# What is the best way to find pay rate

##### Well-known Member
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.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Don't worry. Worked it out. Thanks for trying though.

Replies
3
Views
308
Replies
2
Views
331
Replies
0
Views
1K
Replies
2
Views
348
Replies
2
Views
1K

1,196,073
Messages
6,013,273
Members
441,759
Latest member
ab_

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