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

Reply via email to