Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2015, 12:44 PM
derohanes derohanes is offline searching a range using a value in another cell Windows Vista searching a range using a value in another cell Office 2007
Advanced Beginner
searching a range using a value in another cell
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default

It doesn't like this command. When I select "OK", it highlights "$C$6". (Please see attached image)
Attached Images
File Type: jpg Capture.JPG (71.0 KB, 16 views)
Reply With Quote
  #2  
Old 05-11-2015, 03:01 PM
beginner beginner is offline searching a range using a value in another cell Windows 7 32bit searching a range using a value in another cell Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default

Quote:
Originally Posted by derohanes View Post
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
Attached Files
File Type: xlsx Formulae.xlsx (11.5 KB, 8 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
searching a range using a value in another cell 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
searching a range using a value in another cell 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
searching a range using a value in another cell Limit cell range use talkinglens Excel 6 12-31-2010 08:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft