Hi everyone, I'm trying to write a formula that will analyse a column of data, and, if any entries meet a set requirement, the formula displays the relevant entry from another column. For example, let's I have a set of dates in column I9:I35 (in the format dd/mm/yy). If any of those dates fall in October, I want to display the relevant entry from column J9:J35 in cell A1. So if I have 12/10/23 in cell I14, display the contents of cell J14 in cell A1.
Hope that makes sense, thanks!
Hope that makes sense, thanks!