Forum Discussion
Ability to reference cell while looking up a value
I am completely stumped on how I can go about my situation... My spreadsheet requires a way that I can lookup the value in a cell, which is a formula containing text and math, however that cell is a...
If you are in Sheet2!B1 and you want to reference Sheet1!A1 then you can use the ADDRESS function like this:
=INDIRECT(ADDRESS(ROW(),COLUMN()-1,,,"Sheet1"))