Using INDIRECT within a VLOOKUP formula

T

tevawe

I have a single workbook with 13 worksheets...1 for each month plus a TOTALS
worksheet. In each worksheet there are 4 columns displaying work completed
during the month and at the bottom is a month summary identified by the word
"Totals". On the TOTALS worksheet I want to display only the month's summary
for each column. My TOTALS worksheet has the month listed in column A. For
example A1 = January, A2 = February, etc... To do this my formula looks
like: VLOOKUP("Totals",INDIRECT(A1)!$A:$I,1,FALSE) however I get #N/A. My
expectations of this formula were for the word "Totals" to be found in the
monthly worksheet identified by the INDIRECT formula....in this case Indirect
(A1) should return 'January'. Anyone shed some light on my problem?
 
B

Bob Buckland ?:-\)

Hi Tevawe,

You may want to also post this in the MS Office Excel discussion group using the link below, and when posting there also include the
version of Excel you're using.

=============
I have a single workbook with 13 worksheets...1 for each month plus a TOTALS
worksheet. In each worksheet there are 4 columns displaying work completed
during the month and at the bottom is a month summary identified by the word
"Totals". On the TOTALS worksheet I want to display only the month's summary
for each column. My TOTALS worksheet has the month listed in column A. For
example A1 = January, A2 = February, etc... To do this my formula looks
like: VLOOKUP("Totals",INDIRECT(A1)!$A:$I,1,FALSE) however I get #N/A. My
expectations of this formula were for the word "Totals" to be found in the
monthly worksheet identified by the INDIRECT formula....in this case Indirect
(A1) should return 'January'. Anyone shed some light on my problem?>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top