Linking or Vlookup actual values

[Gene Haines]

I have a workbook with 3 worksheets: Actual Weekly Units Ordered, Projected
Weekly Units Ordered and Analysis. My column headings are set up by dates
for all 3 worksheets, 1/2/2006 thru 12/25/2006. In the analysis worksheet, I
need to pull in the Projected Weekly Units Ordered, however as the current
dated week comes up and the Actual Weekly Units Ordered is entered, I need to
have the Analysis Worksheet pull in the Actual Weekly Units Ordered for the
then current week in lieu of the Projected Weekly Units Ordered for that
week. I hope I made myself clear. Any help would be appreciated. Thank you.

Gene Haines

 

[JLatham]

Do you already have a VLOOKUP() function working to get either one of the
values you need? I'm thinking not because if you are trying to lookup by
dates and your dates are used as column headings, you probably should be
using HLOOKUP().

In either case, you can probably use a nested IF() to choose which to lookup.

 

[JLatham]

Came across 2nd posting with the same question and you seem to have achieved
success there - so I'll drop the subject here.