Hi Neil,
Yes, this can be done but I am not sure if you want the second value
of harmeet in the below cell OR you want that to be add-up in the
first cell value.
Harmeet 100+1000
OR
Harmeet 100
1000
Best Regards,
DILIPandey
On 11/28/10, neil johnson <neil.jh...@googlemail.com> wrote:
> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total there is difference between two . When i see in the
> sheet 1 . there is duplicate name as well as value is difference. can some
> one explain how can we fetch the data by using small function + vlookup
> function + offset function. of second value of harmeet. So total may be
> similar.
>
> I have no complete idea about that .
>
>
> Thanks
>
> --
> ----------------------------------------------------------------------------------
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
