View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default Use Indirect to Select Worksheet

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