Excel Formula to copy value and date to another cell based on date range

I need some help with creating an excel formula. On sheet one, i want to add a value ($100) on cell D5 and a date on cell E5.

Then, sheet two has all the months listed (january to december) down one column from cell A9 to A20.

If the date of E5 (on sheet one) equals March, then i want the value on cell D5 (from sheet one, $100) to appear on sheet two, on the cell next to the corresponding month (as it’s march, i want to see $100 shown on cell B11, sheet two)

By: John Car

Leave a Reply

Your email address will not be published. Required fields are marked *