Hi,

My formula "=IF('Sheet1'!R8="Y",'Sheet1'!A8)" reports back the value of A8 into 'Sheet2' cell A2, as intended, based on the variable in R8 (line 8 is 1st data/non-header row). However, there are merged cells from A8 all the way down to A78. The next value I want reported if true is A79. The problem is all the merged cells in-between report "FALSE." I cannot get rid of the merged cells/rows, and cannot figure out how to display/report only the true values.

Any help would be greatly appreciated.