You VLOOKUP formula will probably have something like this as the
second parameter:

INDIRECT("'"&A1&"'!A:B")

where A1 contains the sheet name and I've assumed you have a two
column table in columns A and B of the sheet where you are trying to
get data from.

Hope this helps.

Pete

On Oct 13, 1:34*pm, Monkey-See, Monkey-Do
wrote:
I want to be able to use values in column A (which match the names of the
worksheet tabs in my workbook), to select which sheet I look up (using
VLOOKUP) values in column B from (which contain values contained in one of
those sheets).

I remember I did this once before using INDIRECT or something similar but I
can't remember exactly how - can anyone help?

Cheers