Posted to microsoft.public.excel.worksheet.functions

Slim Slender[_2_] Slim Slender[_2_] is offline

external usenet poster

Posts: 39

Copy value according to date

Put this formula in B1 and drag/fill down
=IF(ISERROR(VLOOKUP(A1,$E$1:$F$14,2,FALSE)),"",VLO OKUP(A1,$E$1:$F
$14,2,FALSE))

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
Date changes from copy to paste	Nathan	Excel Discussion (Misc queries)	1	December 14th 09 01:30 PM
Copy Date from one spreadsheet to another	Jeff	Excel Discussion (Misc queries)	2	October 9th 08 04:00 PM
Copy Date to Text	knowshowrosegrows	Excel Discussion (Misc queries)	2	October 25th 07 09:43 PM
COPY SAME DATE/CELL TO EVERY SHEET?	Steve	Excel Discussion (Misc queries)	8	October 2nd 06 07:25 PM
How do I copy only the month from a date	CCW	Excel Worksheet Functions	2	April 15th 05 02:26 AM

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

About Us

"It's about Microsoft Excel"