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

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

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

I think this is what you are looking for. Have a look in the below link...

http://www.contextures.com/xlDataVal02.html

If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------



"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

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

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

If this post helps click Yes
---------------
Jacob Skaria


"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