Linking to other sheets

  • Thread starter Thread starter jayhawk1919
  • Start date Start date
J

jayhawk1919

Lets say I have a table on another sheet, and I want to lookup a name
there, then report the value sitting next to it. The sheets names are
such that they have something like "My Sheet 1" then "My Sheet 2" then
"My Sheet 3" etc.

Forgetting the complication of VLOOKUP, since I know how to do that,
how would I refer to the sheets, but get it to change from cell to
cell?

For example, in cell C2 I have ='My Sheet 1'!E1044. How would I get it
so that I could just drag it to cell C3 and it would say ='My Sheet
2'!E1044?

Is there any way to do this?
 
If it is the same workbook sure, you would need some sort of system
that is logical like in your example. You could use indirect

=INDIRECT("'My Sheet "&ROW(1:1)&"'!E1044")

copied down it will return "My Sheet 1", "2", "3" and so on
 
Back
Top