Dear Thakur, I am not sure what you are looking for. Can you elaborate more through a sample file.
If you are willing to vlookup the values based on the names, then vlookup will fetch the first value and will ignore the other values which are in bottom. Further to this, I am not sure what are you trying to achieve through Vlookup. Please explain more on this. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 8/28/10, prabhakar thakur <prabhakarthak...@gmail.com> wrote: > Hi All, > Do not proper result. due to name is repeated in data > than vlookup repeat same all time when ever get same name. > sumproduct also calcuate same as vlookup. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > On Fri, Aug 27, 2010 at 6:25 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi Prabhakar, >> >> Please find the solved workbook attached as per your criteria. >> I have used SumProduct instead of vlookup, get back in case of any >> queries. Thanks. >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On Fri, Aug 27, 2010 at 5:26 PM, prabhakar thakur < >> prabhakarthak...@gmail.com> wrote: >> >>> Dear Dilip, >>> Please find the attachment. >>> >>> >>> Thanks, >>> Prabhakar Thakur >>> New Delhi >>> +919953736776 >>> >>> >>> >>> On Fri, Aug 27, 2010 at 5:10 PM, Dilip Pandey >>> <dilipan...@gmail.com>wrote: >>> >>>> Hi Prabhakar, >>>> >>>> Please provide the sample file for this. Thanks. >>>> >>>> -- >>>> Thanks & Regards, >>>> >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B.Com(Hons),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 62, India >>>> >>>> >>>> >>>> On Fri, Aug 27, 2010 at 12:59 PM, prabhakar thakur < >>>> prabhakarthak...@gmail.com> wrote: >>>> >>>>> Dear All, >>>>> I have a query for using Vlookup with Array >>>>> like >>>>> using Vlookup with Name they have not any unique Data using. >>>>> >>>>> >>>>> Thanks, >>>>> Prabhakar Thakur >>>>> New Delhi >>>>> +919953736776 >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> 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 >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks & Regards, >>>> >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B.Com(Hons),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 62, India >>>> >>> >>> >> >> >> -- >> 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 > -- 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