In my spreadsheet I have 17 cells in a row. If I enter a certain date in cell 1 a text string will appear in one of the other 16 cells, if the date in cell 1 is within a certain date range. How can I make the text string that appears in any one of the cells in the row of cells appear in a cell at the end of the row? The formula is the same in each cell accept for the date range: =IF(AND(C8>=DATE(2011,6,21),C8<=DATE(2011,7,4)),"Period 6 and 7 are 196 hours credit each period","")

Would something like this work? =INDEX(D8:I23,1,MATCH("Period*",D8:I23,0))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

The formula you provided worked perfectly. Thank you

Ask Your Question

Weekly Poll

Were you affected by the Office 365 outage?

Discuss in The Lounge

Poll History