In Sheet1 I want to drag a simple cell reference formula (=Sheet2!B4) down through some merged cells. But when I do that the formula changes by the number of rows that make up the merged cells. What I need is the reference only increase by one 1....rather than the number of rows the the merged cell is.
On the attached example is the final outcome of what it should look like on Sheet1. I need a formula in column G to refence the list of Dates on Sheet2, in order as they're listed. So I need G4 in Sheet1 to pull what's in B4 on Sheet2 (1/5/2021), then when I drag the formula down on Sheet1 to the next merged cell, G8 will equal the next date on the list in column B in Sheet2 (which is cell B5 - 1/7/2021).
Reply With Quote