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 wrote:
> Hi Experts,
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
riginal 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,
>
> Is there any formula we can use to select matched texts just like
> sumif formul
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,
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
--
---
