software

I am using a vlookup fomula in one worksheet whick looks up the data for
each month....Jan, Feb, March... are the column headings. It looks up
values in another workbook, with worksheets for each month...Jan, Feb,
March...are the worksheet names. Is there a way to autofill the
vlookup formulas to change to avoid retyping the Month reference.?

Thanks--
nihad
------------------------------------------------------------------------
nihad's Profile: www.excelforum.com/member.php...oamp;userid=30285
View this thread: www.excelforum.com/showthread...hreadid=538476Example: sheet1 looks like this:
JanFebMar
fooJanfooFebfooMarfoo
barJanbarFebbarMarbar
foobarJanfoobarFebfoobarMarfoobar

Spreadsheet Jan looks like (extrapolate for spreadsheets Feb and Mar):

fooJanfoo
barJanbar
foobarJanfoobar

Formula in sheet1:
=VLOOKUP($A2,INDIRECT(quot;'quot; amp; B$1 amp; quot;'!$A$2:$B$4quot;),2,FALSE)
--
Kevin Vaughnquot;nihadquot; wrote:

gt;
gt; I am using a vlookup fomula in one worksheet whick looks up the data for
gt; each month....Jan, Feb, March... are the column headings. It looks up
gt; values in another workbook, with worksheets for each month...Jan, Feb,
gt; March...are the worksheet names. Is there a way to autofill the
gt; vlookup formulas to change to avoid retyping the Month reference.?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; nihad
gt; ------------------------------------------------------------------------
gt; nihad's Profile: www.excelforum.com/member.php...oamp;userid=30285
gt; View this thread: www.excelforum.com/showthread...hreadid=538476
gt;
gt;