Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel function

Comment:

I am trying to create an Excel template that references two different workbooks. A new workbook must be created every week and must refer to the previous workbook to pull in data. Rather than each week having to go into each cell to change the VLOOKUP formula to reference the exact workbook name (week #), is it possible to have the formula update itself by reference to the “week number” cell on the current worksheet? The only difference between the current week and the previous week is the number (04 in this case) =IF($B9="","",VLOOKUP(B9,'S:\Production Planners\Planner F2007 Archive\[PARALLEL EXEC - Week 04.xls]EXECUTIVE'!$B$9:$Q$225,11,FALSE)) Thanks very much

Can't Delete emails from ...

OE and Messenger

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Is there a excel function that I can use to solve my problem? Help! In sheet 1 I have the follow data: Line No Amount MaturityDate 790 500 12/31/10 790 350 10/8/...

Summary: Hello I am new to excell office tool. I fill two columns (A2:A50 and B2:B50) with some numbers. now I want the sum of these 2 column be in C (I mean Ci = Ai + Bi for 2=i=50). I know how to write a fun...

Summary: Im sure this is really simple. Basically I am trying to make a simple function to create bin labels, instead of having to manually typing them in. Basically, I start at A1A1,A1A2,A1B1,A1B2,...A1D2. I ...