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?