I want to do a lookup using a list of sheet names in a workbook. For example
I want to lookup something in 'Sheet1' and refer to a cell.

Not sure what you exactly want but this may point you in some sort of a
direction:

If say the something you wanted to look up in Sheet 1 was names and dates in
cells A1 to B6:
names ages
fred 23
ada 76
jane 42
jack 36
jill 24


and in your new worksheet (Sheet2) you entered the name of the person you
wanted to find the age for in A1; say
Jane. Then in cell B1 on Sheet 2 enter the following formula:
=VLOOKUP(A1,Sheet1!A1:B6,2,FALSE)
you will see that the answer in B1 is 42.
Now if you change the name in Cell A1 on Sheet2, you will see the age change
accordingly

Hope this helps
Philip
"jhow" wrote in message
...
I want to do a lookup using a list of sheet names in a workbook. For
example
I want to lookup something in 'Sheet1' and refer to a cell.

I don't think this is possible as when you do a lookup you specific a lookup
area or data table which is usually a defined group of cells, opposed to a
worksheet.

The lookup function works by using the data table as a point of reference
and there doesn't seem to be any function that will allow you to select cells
from different sheets under one range name. (You can using the same sheet). I
think the only way you can do this is by using VB code but I can't help you
there.

As an after thought maybe give some throught to using Access to create a
database theat you can reference from all angles???


"jhow" wrote:

I want to do a lookup using a list of sheet names in a workbook. For example
I want to lookup something in 'Sheet1' and refer to a cell.