I would like to fill in the rate vaule in D18-D24.
the formula should look at the effective date in main table 1. if the start date in table 2 is equal or after the effective date in main table 1, then that rate should be applied accordingly.
for example
in table 2, the row with edwin with a start date of 9/31, based on main table 1, 26.50 should be applied in cell D18
in the following row edwin has a start date of 10/22. based on main table 1. Cell D19 Should have 29.32. etc
any help with a simple formula that i can apply in cell D18 and fill in the rest of the column.
Bookmarks