I want to look in 2 different areas and if either area contains what I'm looking like "10" I would like a return of yes or no, but will be happy with true or false. I tried =ISNA and =MATCH with & for multi array. But can not come up with a formula. I am looking in area (AB4:AD17) and (B20:E22).
Formula:
=IF(COUNTIF(AB4:AD17,E7),"Yes",IF(COUNTIF(B20:E22,E7),"Yes","No"))
E7 being the cell you type the number you want to check for.
Last edited by TheMechEngineer; 11-11-2016 at 11:48 PM.
Who needs a life when you have Excel.
Or try this ...
=IF(COUNTIF(AB4:AD17,10)+COUNTIF(B20:E22,10),"Yes","No")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks