Re: $$Excel-Macros$$ Look formula to select ledger group

[NOORAIN ANSARI]

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,
>
> 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
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Ledger Grouping(Solved).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Look formula to select ledger group

[dguillett1]

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 don't know  lookup formulas.

Regards

Rajesh Kainikkara

On 9/13/11, dguillett1  wrote:

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

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel 


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Look formula to select ledger group

[Rajesh K R]

Hi,

Thanks for getting a very quick reply, I don't know  lookup formulas.

Regards

Rajesh Kainikkara

On 9/13/11, dguillett1  wrote:
> 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
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Look formula to select ledger group

[dguillett1]

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

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel 


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel