Hi,

I have a seach criteria in one sheet, that looks at thousands of cells in another sheet.

Formula =IF(COUNTIF(Sheet1!$C$2:$N$6200,E15),"Found","Not Found")

Depending on the outcome of the formula, I would like to copy all of those cells ADJACENT to the cell containing the formula whos outcome is 'Found'


Anyone get what I mean?