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