Using a cell in to lookup another sheet

[newang]

How can I use the cell as the name of the worksheet I want to lookup. e.g in cell B3 I have the text "Glasses", I also have a worksheet with this name. So in the first worksheet, I want my lookup vector to use the cell reference to determine what worksheet to lookup. I have tried just the cell reference B3!..... and I've tried TEXT(B3,)!.... and 'B3'!.... How do I fix this? Thanks.

 

[VoG]

Try INDIRECT http://www.contextures.com/xlFunctions05.html