See attached for solution. On Mon, Mar 1, 2010 at 6:18 AM, Umesh Matkar <matkarum...@gmail.com> wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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
ExcelMacros_DateRangeLookup.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
