I have a sheet1 that references a cell in sheet2. In this case sheet2 is ordered in a specific way but sheet1 is not ordered in the same way, I have to manually find the cell I want to reference.
In sheet1 there is a cell that references a cell in sheet2. I’m trying to create a formula for a cell, also in sheet1, to reference the cell adjacent to the previously mentioned cell in sheet2.
For example: A1 in sheet1 references C3 in sheet2. B2 in sheet1 should reference the cell to the right of the cell that is referenced in A1.
