Please see below link............. http://www.xldynamic.com/source/xld.SUMPRODUCT.html
On Thu, Aug 18, 2011 at 2:18 PM, XLS S <xlst...@gmail.com> wrote: > Ok...............can you give me more information about "--"....... > > Did I use this function anywhere? > > On Thu, Aug 18, 2011 at 2:11 PM, NOORAIN ANSARI > <noorain.ans...@gmail.com> wrote: > > Hi XLS, > > > > -- use for absolute value > > > > other way is this.......... > > =VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE) > > > > On Thu, Aug 18, 2011 at 1:55 PM, XLS S <xlst...@gmail.com> wrote: > >> > >> Hey Noorain, > >> > >> can you tell me what is the mean of ++ and -- > >> > >> > >> > >> > >> > >> On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI > >> <noorain.ans...@gmail.com> wrote: > >> > Dear Subhash, > >> > > >> > Please try it... > >> > =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE) > >> > > >> > > >> > -- > >> > Thanks & regards, > >> > Noorain Ansari > >> > http://noorain-ansari.blogspot.com/ > >> > On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav <scy2...@gmail.com> > >> > wrote: > >> >> > >> >> When I m trying to use to formula VLOOKUP against any formula > generated > >> >> value, there is error. > >> >> Please suggest suitable method for the same, as I have to take many > of > >> >> the > >> >> value based n these types of conditions. > >> >> Sample file attached. > >> >> > >> >> -- > >> >> Subhash Chand Yadav > >> >> > >> >> -- > >> >> > >> >> > >> >> > ---------------------------------------------------------------------------------- > >> >> 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 > >> > > >> > > >> > -- > >> > > >> > > ---------------------------------------------------------------------------------- > >> > 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 > >> > > >> > >> > >> > >> -- > >> ......................... > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> 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, > > Noorain Ansari > > http://noorain-ansari.blogspot.com/ > > > > -- > > > ---------------------------------------------------------------------------------- > > 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 > > > > > > -- > ......................... > > -- > > ---------------------------------------------------------------------------------- > 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, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- 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
