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