thanks noorain..
On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > 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/ > > -- > ---------------------------------------------------------------------------------- > 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
