Linking versus Vlookup

I currently have a workbook with 3 worksheets: Actual Weekly Units Ordered,
Projected Weekly Units Ordered and Analysis. I have 52 weekly columns dated
1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
analysis sheet the projected units ordered by item for all 52 weeks, however
when the actual units ordered by item for the current week are entered into
the Actual Weekly Units Ordered sheet, I need to have that qty replace the
projected qty in the current week of the Analysis sheet. Any help would be
appreciated.
Thank you

Gene Haines

In cell A2 in your Analysis worksheet put the following formula that checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is blank. If it's blank then it puts the Projected amount. If it's not blank it puts the Actual amount.

=IF('Actual Weekly Units Ordered'!A2="", 'Projected Weekly Units Ordered'!A2,'Actual Weekly Units Ordered'!A2)

Hope that helps.
-Ikaabod

Originally Posted by Gene Haines

I currently have a workbook with 3 worksheets: Actual Weekly Units Ordered,
Projected Weekly Units Ordered and Analysis. I have 52 weekly columns dated
1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
analysis sheet the projected units ordered by item for all 52 weeks, however
when the actual units ordered by item for the current week are entered into
the Actual Weekly Units Ordered sheet, I need to have that qty replace the
projected qty in the current week of the Analysis sheet. Any help would be
appreciated.
Thank you

Gene Haines

Ikaaboa: Thanks for your input. I will let you know how I make out.

Regards

Gene Haines

"Ikaabod" wrote:

>
> In cell A2 in your Analysis worksheet put the following formula that
> checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is
> blank. If it's blank then it puts the Projected amount. If it's not
> blank it puts the Actual amount.
>
> =IF('Actual Weekly Units Ordered'!A2="", 'Projected Weekly Units
> Ordered'!A2,'Actual Weekly Units Ordered'!A2)
>
> Hope that helps.
> -Ikaabod
>
> Gene Haines Wrote:
> > I currently have a workbook with 3 worksheets: Actual Weekly Units
> > Ordered,
> > Projected Weekly Units Ordered and Analysis. I have 52 weekly columns
> > dated
> > 1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
> > analysis sheet the projected units ordered by item for all 52 weeks,
> > however
> > when the actual units ordered by item for the current week are entered
> > into
> > the Actual Weekly Units Ordered sheet, I need to have that qty replace
> > the
> > projected qty in the current week of the Analysis sheet. Any help would
> > be
> > appreciated.
> > Thank you
> >
> > Gene Haines
>
>
> --
> Ikaabod
> ------------------------------------------------------------------------
> Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
> View this thread: http://www.excelforum.com/showthread...hreadid=540741
>
>

Thanks for your help Ikaabod. It works fine.

Regards
Gene

"Ikaabod" wrote:

>
> In cell A2 in your Analysis worksheet put the following formula that
> checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is
> blank. If it's blank then it puts the Projected amount. If it's not
> blank it puts the Actual amount.
>
> =IF('Actual Weekly Units Ordered'!A2="", 'Projected Weekly Units
> Ordered'!A2,'Actual Weekly Units Ordered'!A2)
>
> Hope that helps.
> -Ikaabod
>
> Gene Haines Wrote:
> > I currently have a workbook with 3 worksheets: Actual Weekly Units
> > Ordered,
> > Projected Weekly Units Ordered and Analysis. I have 52 weekly columns
> > dated
> > 1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
> > analysis sheet the projected units ordered by item for all 52 weeks,
> > however
> > when the actual units ordered by item for the current week are entered
> > into
> > the Actual Weekly Units Ordered sheet, I need to have that qty replace
> > the
> > projected qty in the current week of the Analysis sheet. Any help would
> > be
> > appreciated.
> > Thank you
> >
> > Gene Haines
>
>
> --
> Ikaabod
> ------------------------------------------------------------------------
> Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
> View this thread: http://www.excelforum.com/showthread...hreadid=540741
>
>