Using input to access different worksheets
 

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...

Hi!

Assume you enter the value in cell A1:

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

Biff

-----Original Message-----
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...

.