Add one cell

[webadam]

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

[Palmetto]

See the Excel help file on VLOOKUP.
You didn't say which direction, left or right, of the reference cell to look, but VLOOKUP only looks to the right.

• IF B1:D100 is the range to look in, and
• Cell A1 hold the value to look up, and
• the value to find is in column-D, then

=VLOOKUP(A1,B1:D100,3,FALSE)

Other options: INDEX/MATCH formula