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

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

2013-07-16 Thread Muralidhar E
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 the results.? Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E