Lookup Help

  • Thread starter Thread starter Tom Ogilvy
  • Start date Start date
T

Tom Ogilvy

Read the help on using Vlookup with ordered data. You need to have a
separate table that has you start dates for the period in the left column
and the period text on the right. The end dates are implicit. Ensure the
table includes conditions for the earliest and latest dates in you data.
You can then use the vlookup to return the appropriate period (4th argument
is True)
 
Hello;

ColumnA is ladeled Date; and is filled with random dates from may, june,
July
ColumnB is labeled period. I need a formula to read the date in columnA and
put the period # in it's place. I tried VLOOKUP but kept getting "10" on all
the returns which is incorrect.

The periods are as follows, 05/26/03 to 06/29/03 = Period 9
06/30/03 to 07/27/03 = Period 10

I need the formula to be able to lookup the date and add the appropriate
period #.
The info starts at A2 and goes to A1456.

Any help with this would be greatly appreciated.

TIA
Lou
 
Back
Top