Thread
: [Solved]
searching a range using a value in another cell
View Single Post
05-11-2015, 09:59 AM
beginner
Windows 7 32bit
Office 2007
Advanced Beginner
Join Date: Sep 2011
Location: Europe
Posts: 45
Quote:
Originally Posted by
derohanes
I want to look for "EP" instead of "EPA".
Try in B2
Code:
=COUNTIF(Sheet1!$B$2:$C$6;"*"&A2&"*")
beginner
View Public Profile
Find all posts by beginner