Use Indirect to Select Worksheet

[pdberger]

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]

Maybe something like:

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

 

[T. Valko]

Try this...

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

 

[Ms-Exl-Learner]

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!

 

[Jacob Skaria]

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