Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-04 Thread hilary lomotey
] *On Behalf Of *resp...@gmail.com *Sent:* Sunday, June 03, 2012 4:23 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Lookup and return 2nd occurrance ** ** Thanks for the explanation. What I like abt this formula is it actually picks not only the 2nd occurance

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread Asa Rossoff
Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Thursday, May 31, 2012 2:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thanks guys I have figured it out

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread respuzy
@googlegroups.com Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance =INDEX($A$1:$B$10,MAX(--($A$1:$A$10=A2)*ROW($A$1:$A$10)),2) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread respuzy
a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 02:42:58 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance Hi Hilary, INDEX(NamesRange,1) returns the first row of the range (which

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread Asa Rossoff
@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Sunday, June 03, 2012 4:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thanks for the explanation. What I like abt this formula is it actually picks not only the 2nd occurance but the last

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-01 Thread hilary lomotey
Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Thursday, May 31, 2012 2:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance ** ** Thanks guys I have figured

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-01 Thread NOORAIN ANSARI
@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance ** ** Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana ** ** -Original Message- From: resp

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-01 Thread hilary lomotey
: $$Excel-Macros$$ Lookup and return 2nd occurrance ** ** Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana ** ** -Original Message- From: resp...@gmail.com Sender: excel-macros

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-01 Thread Haseeb A
Hello Hilary, If you want to return the exact 2nd occurrance value, you can use VLOOKUP like this, =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0) Regards, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-01 Thread hilary lomotey
Thanks Haseeb, will try now, very grateful On Fri, Jun 1, 2012 at 3:53 PM, Haseeb A haseeb.avarak...@gmail.com wrote: Hello Hilary, If you want to return the exact 2nd occurrance value, you can use VLOOKUP like this, =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0)

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread respuzy
Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 31 May 2012 19:42:32 To: excel-macros@googlegroups.com Reply-To:

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread Asa Rossoff
-macros@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Thursday, May 31, 2012 2:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerryR