software

I am trying to make a look up formula that can be drag copied to other
cells, so as to make it easy for muliple users to use the spreadsheet

basically i have a main sheet that consolidates data from 52 other
sheets, each representing a week of the year.
Each sheet is named based on the week,
so 4.8.06
and 4.1.06

the main sheet has 52 additional columns named in the first row the
same as the sheet tab. so the row 1 for the column for 4.1.06 has the
same name as the sheet 4.1.06 where the information is pulled from.

i have a look up formula that checks an item and finds it on the sheet
=VLOOKUP(B6,'4.1.06'!$C$3:$M$221,11,FALSE)
This will be the same for every cell with the exception of the date
part , 4.1.06, i am looking for a way to make this so its easy to drag
copy

something like this, where z1 is where 4.1.06 is stored
=VLOOKUP(B6,Z$1!$C3:$M$221,11,FALSE)

i tried this and kept getting an error, any ideas?

Trav

in row 1--
trav
------------------------------------------------------------------------
trav's Profile: www.excelforum.com/member.php...oamp;userid=31420
View this thread: www.excelforum.com/showthread...hreadid=531710If no spaces in your worksheet names
=VLOOKUP(B6,INDIRECT(Z$1amp;quot;!$C3:$M$221quot;),11,FALSE)

If spaces in your worksheet names
=VLOOKUP(B6,INDIRECT(quot;'quot;amp;Z$1amp;quot;'!$C3:$M$221quot;),11,FA LSE)quot;travquot; wrote:

gt;
gt; I am trying to make a look up formula that can be drag copied to other
gt; cells, so as to make it easy for muliple users to use the spreadsheet
gt;
gt; basically i have a main sheet that consolidates data from 52 other
gt; sheets, each representing a week of the year.
gt; Each sheet is named based on the week,
gt; so 4.8.06
gt; and 4.1.06
gt;
gt; the main sheet has 52 additional columns named in the first row the
gt; same as the sheet tab. so the row 1 for the column for 4.1.06 has the
gt; same name as the sheet 4.1.06 where the information is pulled from.
gt;
gt; i have a look up formula that checks an item and finds it on the sheet
gt; =VLOOKUP(B6,'4.1.06'!$C$3:$M$221,11,FALSE)
gt; This will be the same for every cell with the exception of the date
gt; part , 4.1.06, i am looking for a way to make this so its easy to drag
gt; copy
gt;
gt; something like this, where z1 is where 4.1.06 is stored
gt; =VLOOKUP(B6,Z$1!$C3:$M$221,11,FALSE)
gt;
gt; i tried this and kept getting an error, any ideas?
gt;
gt; Trav
gt;
gt; in row 1
gt;
gt;
gt; --
gt; trav
gt; ------------------------------------------------------------------------
gt; trav's Profile: www.excelforum.com/member.php...oamp;userid=31420
gt; View this thread: www.excelforum.com/showthread...hreadid=531710
gt;
gt;