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

**indukp** · 08-30-2024, 01:12 PM

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. Thanks!

**indukp** · 08-30-2024, 01:55 PM

Also wanted to add that I need one more criteria. Every year I need to add in a 4 % increase.

**JeteMc** · 08-31-2024, 07:13 AM

Try the following:
1. Select cells G1:H1 and drag the fill handle over to cell AC1
2. Paste the following into cell D3 and drag the fill handle over to cell AC3:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return previous date, if date/time in another cell is prior to 6am

[SOLVED] How to return yesterdays date unless today is monday then return previous fridays date

[SOLVED] Excel formula to lookup data and then return Result for Previous Month

Need excel formula previous date to today

[SOLVED] match date name and specific shift and return date in other cell

[SOLVED] Excel 2010 IF formula get cell to return blank, a date +14days or N/A

Using Index and Match instead of VLookup to return the previous column

Bookmarks

Bookmarks

Posting Permissions