Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread Mukesh Gupta
Dear Subhash, You need to use trim command on group code in both sheets...your problem will be resolved. ...Still if you are not able to handle do revert. Regards Mukesh Gupta On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m tryi

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread XLS S
thanks noorain.. On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI wrote: > Please see below link. > http://www.xldynamic.com/source/xld.SUMPRODUCT.html > > On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote: >> >> Ok...can you give me more information about "--"... >> >> D

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread NOORAIN ANSARI
Please see below link. http://www.xldynamic.com/source/xld.SUMPRODUCT.html On Thu, Aug 18, 2011 at 2:18 PM, XLS S 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 >

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread XLS S
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 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, 201

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread NOORAIN ANSARI
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 wrote: > Hey Noorain, > > can you tell me what is the mean of ++ and -- > > > > > > On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI > wrote: > > Dear

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread XLS S
Hey Subhash, also use vlookup with value function, On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav 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

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-18 Thread XLS S
Hey Noorain, can you tell me what is the mean of ++ and -- On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI 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, Ju

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-08-17 Thread NOORAIN ANSARI
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 wrote: > When I m trying to use to formula VLOOKUP against a

RE: $$Excel-Macros$$ Vlookup against the value generated from formula

2011-07-25 Thread Rajan_Verma
Use this =VLOOKUP(VALUE(C5),Sheet3!$A$1:$D$403,4,FALSE) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Subhash Yadav Sent: Monday, July 25, 2011 6:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup against the value generated f