DP7 wrote:
I have an indirect formula that I am trying to get working. See below
for formula.
=INDIRECT(" ' "&$C$16&"!"&ADDRESS(ROW(B2),COLUMN(B2)))
With this formula I want to be able to pick up values from a list
which are names of different tabs in the workbook. When the name is
picked it will show the values which are on each tab. If anyone can
figure this out I would be very grateful. Thanks in advance.


Try:
=INDIRECT("'"&$C$16&"'!"&ADDRESS(ROW(B2);COLUMN(B2 )))

Hans