Dear Rajesh,
Apart from VLookup you can also use simple..
*=LOOKUP(2,1/($A$2:$A$8=A11),$B$2:$B$8)*
*=INDEX($B$2:$B$8,MATCH($A11,$A$2:$A$8,0))*
*=OFFSET($B$1,MATCH($A11,$A$2:$A$8,0),0)
See attached sheet..*
*
*
On Tue, Sep 13, 2011 at 12:21 AM, Rajesh K R
Hi Experts,
Is there any formula we can use to select matched texts just like
sumif formula(in case of numbers).Kindly find the attached file it
ellaborate well about the issue.And tell me how to solve it.
Regards
Rajesh Kainikkara
--
It appears that a simple vlookup should do it.
=IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0)))
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:51 PM
To: excel-macros
Subject: $$Excel-Macros$$ Look formula to select ledger group
Hi Experts
-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:51 PM
To: excel-macros
Subject: $$Excel-Macros$$ Look formula to select ledger group
Hi Experts,
Is there any formula we can use to select matched texts just like
sumif formula(in case of numbers).Kindly find the attached file
Just put in the top cell and use the fill handle to copy down
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 2:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Look formula to select ledger group
Hi,
Thanks for getting a very quick reply, I