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
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,
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,
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
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
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
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
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
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
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
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
11 matches
Mail list logo