Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-07 Thread NOORAIN ANSARI
Dear Aamir, 1 use for Lookup range, 2 use for target column -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Jan 6, 2012 at 11:20 PM, Aamir Shahza

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Aamir Shahzad
in choose function why use {1,2} for. Kindly brief: ,CHOOSE({1,2},$C$2:$C$15,$B$2:$B$15) On Fri, Jan 6, 2012 at 7:06 PM, NOORAIN ANSARI wrote: > okay thanks > > > > > On Fri, Jan 6, 2012 at 7:26 PM, Kris wrote: > >> @ Noorain, >> >> No need to CSE LOOKUP(2,1/ ) formula. >> >> It is a non ar

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread NOORAIN ANSARI
okay thanks On Fri, Jan 6, 2012 at 7:26 PM, Kris wrote: > @ Noorain, > > No need to CSE LOOKUP(2,1/ ) formula. > > It is a non array formula, but it's expensive as much as an array formula > because of the division. > > Kris > > -- > FORUM RULES (986+ members already BANNED for violation)

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Kris
@ Noorain, No need to CSE LOOKUP(2,1/ ) formula. It is a non array formula, but it's expensive as much as an array formula because of the division. Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

RE: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Asa Rossoff
. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jai Sent: Friday, January 06, 2012 2:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ want to solution of Vlookup limitation you use only =vlookup formula

RE: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Rajan_Verma
Hi Please see the attachment.. Regards Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 04:26 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ want to solution of Vlookup limitation Dear

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread NOORAIN ANSARI
gt; Date: Fri, 6 Jan 2012 15:30:57 +0530 > Subject: $$Excel-Macros$$ want to solution of Vlookup limitation > From: ashishbhalar...@gmail.com > To: excel-macros@googlegroups.com > > > Dear experts, > > There are a limitation of vlookup that it find out the value only from

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread NOORAIN ANSARI
Dear Ashish, =VLOOKUP(G4,CHOOSE({1,2},$B$2:$B$9,$A$2:$A$9),2,0) On Fri, Jan 6, 2012 at 3:30 PM, Ashish Bhalara wrote: > Dear experts, > > There are a limitation of vlookup that it find out the value only from > right side of the lookup_value. I require the value from left side of > lookup_value

RE: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Kashan Abbas
Put your lookup column on the right side by using = signg, otherwise use index match function INDEX(CA!$B$7:$D$931,MATCH(A5,CA!$B$8:$B$931,0),3) Date: Fri, 6 Jan 2012 15:30:57 +0530 Subject: $$Excel-Macros$$ want to solution of Vlookup limitation From: ashishbhalar...@gmail.com To: excel

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Jai
you use only =vlookup formula On Fri, Jan 6, 2012 at 3:30 PM, Ashish Bhalara wrote: > Dear experts, > > There are a limitation of vlookup that it find out the value only from > right side of the lookup_value. I require the value from left side of > lookup_value. > Is there any solu

$$Excel-Macros$$ want to solution of Vlookup limitation

2012-01-06 Thread Ashish Bhalara
Dear experts, There are a limitation of vlookup that it find out the value only from right side of the lookup_value. I require the value from left side of lookup_value. Is there any solution for this type of query? Thanks & regards. Ashish Bhalara -- FORUM RULES (986+ members already BANNED fo