Hi All,
I am currently working on a budget planner, I have two columns (In example A & C) of dates of a whole month(3 of each day) which changes in number of cells depending on the month (ie February 28 days etc) I would like to be able to add text in column B and then if the dates in column A and C match I would like to return the relevant cell from Column B into Column D
I have tried a few different formulas that seem to work but for example they return the same value in all 3 cells even if it appears in only one
Please see attached example
Thanks for any help
Ashley
Bookmarks