Posted to microsoft.public.excel.programming

snax500[_2_] snax500[_2_] is offline

external usenet poster

Posts: 29

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Utilizing a RANDBETWEEN() formula within a LOOKUP formula	Rich Werk.	Excel Discussion (Misc queries)	4	November 4th 09 03:01 AM
need help with lookup formula	Gil[_2_]	Excel Worksheet Functions	5	January 31st 08 03:09 AM
Lookup and Use a Formula	TKS_Mark	Excel Discussion (Misc queries)	8	January 5th 08 01:45 AM
Lookup formula	Rowland	Excel Worksheet Functions	2	February 1st 07 03:29 PM
Lookup Formula - but have a formula if it can't find/match a value	Stephen	Excel Worksheet Functions	11	June 14th 05 05:32 AM

All times are GMT +1. The time now is 02:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us