Using input to access different worksheets

G

Guest

Is there a way in excel that you can enter a value and it will access the
approporiate worksheet. For example, I have worksheets labelled WS1, WS2 and
WS3. If I enter a value of "1", I want it to pull the value from cell A2 of
WS1, if I enter "2" it will pull the value of cell A2 from WS2 and so on...
 
B

Biff

Hi!

Assume you enter the value in cell A1:

=IF(A1="","",INDIRECT("WS"&A1&"!$A$2"))

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking worksheet and multiple cells 1
Excel - Using input to access different worksheets 1
Find last cell in a column, Delete its contents and make it active 5
Auto update some spreadsheets inside a shared workbook and NOT others 0
Using cell's contents as an index to a row ...? 3
Importing relative positoin information 2
Retrieving a field from another worksheet - with conditions... 3
Sum.If function but depending on 3 different columns? 7

Top