Posted to microsoft.public.excel.misc

external usenet poster

Posts: 718

IF or vlookup formula

I am trying to return the values of column Ain column C if the dates in
column B are between 31/12/2008 and 01/01/2010

Column A Column B Column C
1040 24/12/2008 1042
1042 03/01/2009 1041
1041 21/06/2009 1043
1043 21/12/2009
1045 03/01/2010

Have tried =IF(AND(B:B31/12/2008,B:B<01/01/2010),A:A,0)

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
Alternative formula to the vlookup formula?	Victor	Excel Worksheet Functions	2	May 12th 08 04:38 PM
convert vlookup formula to link formula	AFA	Excel Worksheet Functions	0	February 20th 08 04:24 AM
VLOOKUP Formula	Jackie	Excel Discussion (Misc queries)	2	July 18th 07 09:58 PM
Using VLOOKUP formula	Mahadevan Swamy	Excel Discussion (Misc queries)	5	June 28th 07 08:47 PM
Excel 2002 VLOOKUP formula or other formula	Serge	Excel Discussion (Misc queries)	4	February 26th 07 03:56 PM

All times are GMT +1. The time now is 11:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us