thanks sir,but can u tell me that how to use in many columns, i means how can i define column name because i have many columns in that i have to apply vlookup request,can u to plz send me the solution in excel file it will be very helpful for me.one more thing iwant to ask u that i want a macro for sumproduct also so it will be very helpful if u can send me both formula in macro will solve mu problem. thanks in advance
On 5/8/11, rajan verma <rajanverma1...@gmail.com> wrote: > Dim LookUp_value as variant > Dim LookupVector as range > Dim ColNum as Integer > Dim ans as Variant > 'Assign the Values to Variables > > Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0) > > > > On Sun, May 8, 2011 at 4:45 AM, STDEV(i) <setiyowati.d...@gmail.com> wrote: > >> It would be easy for anyone in the group to respond, if you can send a set >> of sample data. >> >> >> On Sat, May 7, 2011 at 1:47 PM, maulik desai >> <mauliksde...@gmail.com>wrote: >> >>> Hi All, >>> >>> I have excel database sheet >>> I have created some excel output sheets (around 35 excel sheets) which >>> gives me output data with the help of Vlookup fuction. >>> But the problem is in every 3 months I have to change the database month >>> name & because of that I need to change the vlookup range also in output >>> sheets manually (need to open each sheet &change the new file name in >>> that) >>> >>> Is there any way that whenever I changed the file name of database ,the >>> same new range also updated in output sheets automatically. >>> >>> Thanks In advance. >>> >>> -- >> >> ---------------------------------------------------------------------------------- >> 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/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > -- Thanks & Regards, Maulik Desai 9967363926 -- ---------------------------------------------------------------------------------- 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/discussexcel
