R
Rusty
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
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