I have cell A6 with a formula that produces a text message with a record number when there exists a content match of a SS # in cell B10 within a defined range of cells: =IF(MATCH($B$10,Curr_Cycle_SS_Nos,0)>0,"SS # matches record "&MATCH($B$10,Curr_Cycle_SS_Nos,0)&" in batch.","") The formula...