Hi,
Is it possible to lookup the value of a cell in the column next to the one being referenced. So something like:
=Sheet!(C22+1)
However the '1' would be a variable in another cell, so it could be changed to 2 or 3 columns across from the cell being referenced.
edit: forgot about the offset function. solved
Bookmarks