Maybe something like:

=vlookup(x99,indirect("'" & F3 & "'!A:e"),5,false)



pdberger wrote:

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

--

Dave Peterson