hi priti,
very nice formula.. very useful. thank you.
Thanks Regards,
Prabhu R
On 16 July 2013 14:57, priti verma pritiverma1...@gmail.com wrote:
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup
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
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
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
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 emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the
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 noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Please visit here..
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 vijay.4...@gmail.com wrote:
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible
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 emuralidha...@gmail.com wrote:
Hi,
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 emuralidha...@gmail.comwrote:
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
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,
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com 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 emuralidha...@gmail.comwrote:
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E emuralidha...@gmail.com wrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last
Repected Vijay Kumar and Noorain Ansari.
Both of u and the team Thank u very much.
On 16 July 2013 16:46, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
See the following link and attached File.
http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
Regards,
Vijaykumar
12 matches
Mail list logo
