searching a range using a value in another cell

derohanes · #1 05-11-2015, 12:44 PM

It doesn't like this command. When I select "OK", it highlights "$C$6". (Please see attached image)

beginner · #2 05-11-2015, 03:01 PM

Quote:

Originally Posted by derohanes

It doesn't like this command. When I select "OK", it highlights "$C$6". (Please see attached image)

Replace the semicolon with a comma

Code:

=COUNTIF(Sheet1!$B$2:$C$6,"*"&A2&"*")

Please you see atachment

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If id cell range is empty then should not allow to fill any other cell	ubns	Excel Programming	2	04-12-2015 06:31 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)	lily	Excel	9	10-23-2014 06:21 AM
VLOOKUP looking at another cell for its range	Rich18144	Excel	1	06-24-2014 07:56 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Limit cell range use	talkinglens	Excel	6	12-31-2010 08:43 PM