using a cell to pull data from different worksheets

  • Thread starter Thread starter toomis
  • Start date Start date
T

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
 
toomis said:
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
Click to expand...
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.
 
Back
Top