| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check multiple cells for a match
I am trying to create a formula that checks multiple specific cells and then
returns a "YES" if it matches or a "NO" if it doesn't match any of the cells. example I have two worksheets - 1 and 2 I want to search these cells only on worksheet 1- cells B3, B24, B63, B78, B89 (But none of the cells in between such as B4, B35, etc) for a match with worksheet 2 cell A2. Is this possible? TIA. Rusty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check multiple cells for a match
=IF(OR(B3=Sheet2!A2,B24=Sheet2!A2,B63=Sheet2!A2,B7 8=Sheet2!A2,B89=Sheet2!A2),"Yes","No")
Regards, Stefi €˛Rusty€¯ ezt Ć*rta: I am trying to create a formula that checks multiple specific cells and then returns a "YES" if it matches or a "NO" if it doesn't match any of the cells. example I have two worksheets - 1 and 2 I want to search these cells only on worksheet 1- cells B3, B24, B63, B78, B89 (But none of the cells in between such as B4, B35, etc) for a match with worksheet 2 cell A2. Is this possible? TIA. Rusty |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check multiple cells for a match
Or a macro approach. Modify to suit
Sub checkcertaincells() For Each i In Range("c4,c6,c10") If i = Range("f7") Then mycount = mycount + 1 Next i If mycount 0 Then MsgBox "There are " & mycount & " matches" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Rusty" wrote in message ... I am trying to create a formula that checks multiple specific cells and then returns a "YES" if it matches or a "NO" if it doesn't match any of the cells. example I have two worksheets - 1 and 2 I want to search these cells only on worksheet 1- cells B3, B24, B63, B78, B89 (But none of the cells in between such as B4, B35, etc) for a match with worksheet 2 cell A2. Is this possible? TIA. Rusty |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check multiple cells for a match
Thanks Stefi and Don. I'll go with Stefi's as it was the first one I tried
and it is working great. Thankyou "Stefi" wrote: =IF(OR(B3=Sheet2!A2,B24=Sheet2!A2,B63=Sheet2!A2,B7 8=Sheet2!A2,B89=Sheet2!A2),"Yes","No") Regards, Stefi €˛Rusty€¯ ezt Ć*rta: I am trying to create a formula that checks multiple specific cells and then returns a "YES" if it matches or a "NO" if it doesn't match any of the cells. example I have two worksheets - 1 and 2 I want to search these cells only on worksheet 1- cells B3, B24, B63, B78, B89 (But none of the cells in between such as B4, B35, etc) for a match with worksheet 2 cell A2. Is this possible? TIA. Rusty |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check multiple cells for a match
You are welcome! Thanks for the feedback!
Stefi €˛Rusty€¯ ezt Ć*rta: Thanks Stefi and Don. I'll go with Stefi's as it was the first one I tried and it is working great. Thankyou "Stefi" wrote: =IF(OR(B3=Sheet2!A2,B24=Sheet2!A2,B63=Sheet2!A2,B7 8=Sheet2!A2,B89=Sheet2!A2),"Yes","No") Regards, Stefi €˛Rusty€¯ ezt Ć*rta: I am trying to create a formula that checks multiple specific cells and then returns a "YES" if it matches or a "NO" if it doesn't match any of the cells. example I have two worksheets - 1 and 2 I want to search these cells only on worksheet 1- cells B3, B24, B63, B78, B89 (But none of the cells in between such as B4, B35, etc) for a match with worksheet 2 cell A2. Is this possible? TIA. Rusty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match multiple cells | Excel Discussion (Misc queries) | |||
| link check boxes in multiple cells | Excel Discussion (Misc queries) | |||
| syntax for "IF" commend to check for multiple empty cells bf comma | Excel Worksheet Functions | |||
| Check if 2 cells match on another sheet then lookup value | Excel Worksheet Functions | |||
| How to check multiple cells | Excel Worksheet Functions | |||
Linear Mode
