Thread: Lookup Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500[_2_] snax500[_2_] is offline
external usenet poster
 
Posts: 29
Default Lookup Formula

In Excel2000, I have the following data:

Weekending Fiscal Month
2/19/2005 FEB
2/26/2005 FEB
3/5/2005 MAR
3/12/2005 MAR

I want to have a lookup formula that looks up all dates before the
weekending date. For example for the following:

2/25/2005 = Feb
2/26/2005 = Feb
2/27/2005 = Mar
2/28/2005 = Mar
2/29/2005 = Mar
3/1/2005= Mar

Thanks