Pls suggest formula ..for below conditions
>From To Codes
Jul-09 Sep-09 JS0909
Apr-09 Jun-09 AJ0909
Oct-08 Mar-09 OM0809
Apr-08 Sep-08 AS0808
Oct-07 Mar-08 OM0708
Oct-06 Sep-07 OS0607
Sep-06 TS06 (sep-06 and greater than that ..means jan04,
aug06 etc)
Dear friends...i want to put codes from above table to below tables..if
below table date is belong to above table range..than I want to put there
code from that particular range.
Month codes
Jan-06
Apr-06
May-06
Oct-06
Aug-06
Aug-06
Oct-06
Nov-06
Feb-07
Feb-07
Mar-07
Aug-07
Oct-07
Jul-08
Oct-08
Oct-08
Nov-08
Dec-08
Mar-09
Apr-09
Sep-07
Nov-08
May-07
May-02
Jun-04
Oct-04
Thanx
Umesh
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
