Referencing a worksheet from a cell value
Posted by Robert M. Zigweid on February 22, 2000 9:20 AM
I'm trying to reference a worksheet on my rather large workbook based upon the value of a cell.
My problem is, using INDIRECT()
The present formula looks something like this:
=INDIRECT("'" & W5 & "'!$R$3:$S$6433")
where w5 is the cell that points to the worksheet.
This value is going to be used in a VLOOKUP() if that makes any difference.
The problem with the above formula is that it returns Volatile and seems unusable to the VLOOKUP.
Any suggestions are most welcome.
Robert M. Zigweid
Posted by Celia on February 22, 2000 4:17 PM
Robert
Your formula cannot stand alone since it is trying to put all of the values in the range S3:R6433 into one cell.
The INDIRECT function can be used as part of a formula. For example :
=VLOOKUP(value,INDIRECT("'" & W5 & "'!$R$3:$R$6433"),columnindex)
Celia
