hi Dilip,
u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) then whts the problem ? On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar <bhawar.prs...@gmail.com>wrote: > hi Dilip, > > u use formula > =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) > > if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) > then whts the problem ? > > > On Sat, Oct 3, 2009 at 3:28 PM, <equitym...@gmail.com> wrote: > >> Thx a lot >> >> Sent from my BlackBerry® smartphone from Tata Indicom >> ------------------------------ >> *From: * Dilip Pandey <dilipan...@gmail.com> >> *Date: *Sat, 3 Oct 2009 15:04:03 +0530 >> *To: *<excel-macros@googlegroups.com> >> *Subject: *$$Excel-Macros$$ Re: Enable V Look up Option on the Excel >> Sheet. >> >> Hi, >> >> As requested, v-lookup function is incorporated in the attached workbook. >> Note, you have to define something else instead of "fund Name" as a >> base data to be looked for because the same names are appearing more than >> once. For example, fund Id or fund number can work. Thanks, >> >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/3/09, Equity Monk <equitym...@gmail.com> wrote: >>> >>> Dear Friends, >>> >>> I am attaching a portfolio. It is a mf portfolio. >>> If you can pls attach a v look up function to it that would be great. >>> >>> The website from where the link can come is http://www.amfiindia.com/. >>> >>> Looking fwd to your help. >>> >>> >>> >> >> >> >> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
