hi Dilip, Thank u very much for contributing time for me. But I am facing some problem in the given file.
Actually I need this: When I select 01.04.2010 to 30.04.2010 it will show april, if date is from 01.05.2010 to 31.05.2010 it will show may, when date will cross 30.04.2010 from 01.04.2010 it will show qtr1, if date is from 01.04.2010 to 10.04.2010 it will show TDP, If I select date from 21.04.2010 to 20.05.2010 It will show MOC2...........like this you please see the raw data sheet there u get the details of TDP MOC etc. On Wed, Sep 8, 2010 at 6:25 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Kalyan, > > Please find the vlookup function working properly in the attached file. > > Feel free to write back in case of any queries. > > Warmest Regards, > DILIPandey > > On 9/8/10, Kal xcel <kalx...@gmail.com> wrote: > > Dear Experts, > > > > I need a help, I want to lookup value from selected dates. > > > > File is attached > > > > Thanks in advance > > > > Kalyan > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 7000 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
