Variable Cell Location on a different sheet


Posted by Don on January 22, 2002 6:56 AM

I can't seem to figure out how to have the value of a cell be referencing different cells on a different sheet.

Example:
A formula results in cell G2 being 11 on sheet One
I want cell E6 on sheet One to be whatever's in Row 11, Column M on sheet Two.
Normally, this would be E6=Two!M11
However, the 11 needs to be picked up from G2
something like E6=Two!M{G2}
of course that doesn't work. What would?



Posted by Tom Dickinson on January 22, 2002 10:21 AM

E6=INDIRECT("Two!M" & G2) (NT)