Thanks for reply. With Regards,
Hitesh. ________________________________ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, May 06, 2010 3:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula USE THIS ONE =VLOOKUP(C6,INDIRECT(B6&"!A:I"),2+MATCH('Inv for Rate'!D6,INDIRECT(B6&"!$C$2:$I$2"),0),0) Inv for Rate'!D6, specifies the value of cell d6 of sheet name Inv for Rate' On Thu, May 6, 2010 at 11:48 AM, vidyut more <vidyutm...@gmail.com> wrote: Thnaks for ur sollution. I have given sample ,anybody has formula for to many parties and rate is different for each party i want to know. On Thu, May 6, 2010 at 10:19 AM, Hitesh Dilipbhai Dhare <hitesh.dh...@idea.adityabirla.com> wrote: > Can you tell me, what is the meaning of following argument in the solution > provided? > > > > 'Inv for Rate'!D8 > > > > With Regards, > > Hitesh > > ________________________________ > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of ashish koul > Sent: Wednesday, May 05, 2010 10:59 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula > > > > check the attachment > > On Wed, May 5, 2010 at 6:56 PM, vidyut more <vidyutm...@gmail.com> wrote: > > I have attached sample file. I want formula for picking up rate from > excel sheets. 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 <http://www.excel-macros.blogspot.com/> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 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 > > > > -- > ------------------------------------------------------------------------ ---------- > 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 <http://www.excel-macros.blogspot.com/> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 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 > > ************************************************************************ > ideacellular.com <http://ideacellular.com/> E-Mail Domain is now idea.adityabirla.com <http://idea.adityabirla.com/> E-Mail Domain > ************************************************************************ > ************************************************************************ ****************************** > Visit www.ideacellular.com <http://www.ideacellular.com/> to know more about latest Products, tariffs, > online payments and recharges. > ************************************************************************ ****************************** > An idea can change your life. ************** LEGAL DISCLAIMER ************ > This E-Mail may contain Confidential and/or legally privileged Information > and is meant for the intended recipient(s) only. If you have received this > e-mail in error and are not the intended recipient/s, kindly notify us at > mailad...@idea.adityabirla.com and then delete this e-mail immediately from > your system. You are also hereby notified that any use, any form of > reproduction, dissemination, copying, disclosure, modification, distribution > and/or publication of this e-mail, its contents or its attachment/s other > than by its intended recipient/s is strictly prohibited and may be unlawful. > Internet Communications cannot be guaranteed to be secure or error-free as > information could be delayed, intercepted, corrupted, lost, or contain > viruses. IDEA Cellular Limited does not accept any liability for any errors, > omissions, viruses or computer problems experienced by any recipient as a > result of this e-mail. > > -- > ------------------------------------------------------------------------ ---------- > 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 <http://www.excel-macros.blogspot.com/> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 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 > -- ------------------------------------------------------------------------ ---------- 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 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 -- ------------------------------------------------------------------------ ---------- 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 6,800 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 ************************************************************************ ideacellular.com E-Mail Domain is now idea.adityabirla.com E-Mail Domain ************************************************************************ ****************************************************************************************************** Visit www.ideacellular.com to know more about latest Products, tariffs, online payments and recharges. ****************************************************************************************************** An idea can change your life. ************** LEGAL DISCLAIMER ************ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at mailad...@idea.adityabirla.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. -- ---------------------------------------------------------------------------------- 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 6,800 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
