To begin, I apologize if I'm using the wrong Excel nomenclature.
I have a sheet, Sheet2, that has formulas in it but it references another sheet's (Sheet1) cells directly. I have already automated this so it would populate and adjust accordingly. Not all Sheet1 rows' data is pulled, only the ones that are marked are pulled over to Sheet2.
I've already pulled a list of the cell's addresses (Example: J10, J15, J20) from Sheet1 to Sheet2 and have that automated but I also need to access the other data on the same row of that cell's address from Sheet1.
For Example
I've pulled a cell's address, J10, from Sheet1, but I also want access to B10, D10, and F10 from Sheet1. Everything, however, is tied to J10 since that's the only cell that updates. (If the parameters changed and I needed to use J11 instead of J10, Sheet2 automatically changes to J11 and I would want it to pull B11, D11, F11, etc instead).
Inside of Sheet2 I tried using the OFFSET function but even though the cell references and pulls from Sheet1 the formula offsets the value in Sheet2.
For Example
In Sheet2:
The B25 cell is $J$10, that was pulled from Sheet1
=OFFSET(B25, 0, 3) gives me what's in E25 from Sheet2 rather than M10 from Sheet1.
Not sure what to try next, if anybody knows what to do please do let me know. Thanks!
I hope this makes sense, thanks!
edit: So I thought of a workaround which is just inputting the formula that I used to grab the initial value itself and offsetting that. I would still love to figure out the answer to the question above however.
=OFFSET(my formula i used, 0, 3) and putting that inside of the other formula
Bookmarks