Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-20 Thread Prabhu Pinky
hi priti, very nice formula.. very useful. thank you. Thanks & Regards, Prabhu R On 16 July 2013 14:57, priti verma wrote: > PFA > > > On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote: > >> >> Dear Friends good afternoon, >> >> I need help reg. lookup values >> >> 1.It is possible to vlook

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
Repected Vijay Kumar and Noorain Ansari. Both of u and the team Thank u very much. On 16 July 2013 16:46, P.VIJAYKUMAR wrote: > Respected Muralidhar, > > See the following link and attached File. > http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ > > Regards, > Vijaykumar > > > On Tue,

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
Dear Vijay Kumar. Thank u On 16 July 2013 16:40, Muralidhar E wrote: > Thank u > > > > On 16 July 2013 16:34, NOORAIN ANSARI wrote: > >> Dear Muralidhar. >> >> it's the largest number that Excel can store. This "Big number" is used >> to look up the last number in a range. >> >> >> On Tue,

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
Thank u On 16 July 2013 16:34, NOORAIN ANSARI wrote: > Dear Muralidhar. > > it's the largest number that Excel can store. This "Big number" is used to > look up the last number in a range. > > > On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote: > >> >> Thanks mr, Ansari, >> >> I cant under

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR
Respected Muralidhar, You can see the following links for Examples http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html http://www.youtube.com/watch?v=IX2TZ3OlOlA http://www.randomwok.com/excel/how-to-use-index-match/ Regards, Vijaykumar On Tue, Jul 16, 2013 at 3:37 PM, Mura

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread NOORAIN ANSARI
Dear Muralidhar. it's the largest number that Excel can store. This "Big number" is used to look up the last number in a range. On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote: > > Thanks mr, Ansari, > > I cant understand the 9E+307 in the below formula > > =LOOKUP(9E+307,1/(C3:C9=E9),B3:B

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
Thanks mr, Ansari, I cant understand the 9E+307 in the below formula =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9) plz, help me on this with an example,it is help me more. Thanks in advance Warm Regards, Muralidhar On 16 July 2013 15:37, Muralidhar E wrote: > Hi, > > ThanksVijay. can u present me w

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread Muralidhar E
Hi, ThanksVijay. can u present me with an example,it is better to understand me. Thanks in advance. On 16 July 2013 15:07, P.VIJAYKUMAR wrote: > Respected Muralidhar, > > You can use Index,Match,Indirect functions for accomplishing some look up > tasks which are not possible by VLookup. > > R

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR
Respected Muralidhar, You can use Index,Match,Indirect functions for accomplishing some look up tasks which are not possible by VLookup. Regards, VijayKumar On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI wrote: > Dear Murlidhar, > > Please visit here.. > > http://www.excelvbaclinic.com/2011/0

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread NOORAIN ANSARI
Dear Murlidhar, Please visit here.. http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote: > > Dear Friends good afternoon, > > I need help reg. lookup values > > 1.It is possible to vlookup the values for the left side > 2.Vlo

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

2013-07-16 Thread priti verma
PFA On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote: > > Dear Friends good afternoon, > > I need help reg. lookup values > > 1.It is possible to vlookup the values for the left side > 2.Vlookup for the second value(occurence), third value > Is their any other ways or functions to get th