PDA

View Full Version : EXCEL - using cell contents to point to a worksheet



DavidRennox
28-07-2006, 03:04 AM
In Excel, how can I use the contents of a cell in a formula to direct to a specific worksheet.

I have several worksheets and I want to extract the contents of a cell on a specific worksheet by using the contents of a cell to name the worksheet.

i.e. Suppose I want to access the value of cell F5 on worksheet "sheet1".
In cell A1 of the current worksheet is the text "sheet1".
So, instead of the formula being "=sheet1!F5" I want it to be "A1!F5" so that, as I change the value of A1, I get the value of cell F5 from a different worksheet.

stu161204
28-07-2006, 11:59 PM
** bump **

andrew93
29-07-2006, 12:20 AM
Hi David and welcome to PressF1!

Try using the indirect function, like this :

=INDIRECT(A1&"!F5")

If both the sheet and cell are referenced the same way, try this instead :

=INDIRECT(A1&"!"&B1)

where A1 has the sheet name and B1 has the cell reference.

HTH, Andrew