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
