Try this...

=INDIRECT("'"&F3&"'!A1")

--
Biff
Microsoft Excel MVP


"pdberger" wrote in message
...
Good evening --

I have three lookup tables, and would like the user to be able to select
which one (s)he wants. They are pretty much identical, on worksheets
named
"2008", "2009", and "2010". On the active worksheet, cell F3 allows the
user
to select which one to use.

How do I use INDIRECT to select cell A1 on a worksheet selected by an
entry
in cell F3?

Thanks in advance