Hi All,
I have 2 sheets in a spreadsheet. 1 has raw data, the other will be the organized version of the first sheet.
In cell B2 of my second sheet, I want to call a cell from the other sheet. Lets say cell B1 (=Sheet1!B1)
In cell B3 of my second sheet, I want to call the cell that is 2 columns over & 12 rows down from the cell I called in cell B2 of sheet 2 (=Sheet1!D13). But I want the formula for cell B3 to be based on which cell is referenced in cell B2. I want to do this because I have a repeating dataset that will always have the info I want 2 cells over and 12 cells down from some cell in the dataset.
I hope this makes sense. Basically, how do I call a cell 2 over & 12 down from a cell I reference?
Thanks All,
Jake
Bookmarks