using a cell to pull data from different worksheets

[toomis]

hi,

was wondering if there is a way to pull data from different worksheets
whenever i change a cell pointer.

normally you would have

=Sheet1!A1 to get data from a worksheet named sheet1

i want to use a lookup table that would select different worksheets
such as

1 sheet1
2 sheet2
3 sheet3
4 sheet4
etc, etc, etc

so that if i enter 3 in the lookup table, it would replace sheet1 in
the formula above with sheet3. i am able to do this with macros but was
hoping that there is a way to do this without using macros.

thanks for any help,

tom

 

[Eric Larsen]

hi,

was wondering if there is a way to pull data from different worksheets
whenever i change a cell pointer.

normally you would have

=Sheet1!A1 to get data from a worksheet named sheet1

i want to use a lookup table that would select different worksheets
such as

1 sheet1
2 sheet2
3 sheet3
4 sheet4
etc, etc, etc

so that if i enter 3 in the lookup table, it would replace sheet1 in
the formula above with sheet3. i am able to do this with macros but was
hoping that there is a way to do this without using macros.

thanks for any help,

tom

Highlight the data that you want than click Insert, Name, Define, name the
range.
Now you only need to refer to Range name when refering to this sheet's data.
Example (Vlookup,A1,"Name"2,0) where name is the range you named.