Excel formula match date and return value and then look in the previous cell

[indukp]

I need a formula where it looks up the date and matches the start date with the date in Cell B3 and then divided the annual salary by 12. In the attached file I want the amount of 12K to appear in F3 by matching it with cell B3. Then in cell G3 it will first match the date and then if the value does not match, it will look at the previous cell in F 3 and return the value in G3. I have attached an excel file with the example. Please help me out with a formula. Also wanted to add that I need one more criteria. Every year I need to add in a 4 % increase. Thanks!

[AliGW]

You have marked this thread as solved - is it?

Administrative Note:

Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.