Can the IF function be used over a range across multiple worksheets and multiple cells?
Here is the scenario:
I want to use an IF function to determine whether the word "Verify" is in a range of cells (B10:C20) across multiple worksheets ('Alpha:Delta'!).
If not possible, is there an alternative (strictly formula based)?
Thanks!
Here is the scenario:
I want to use an IF function to determine whether the word "Verify" is in a range of cells (B10:C20) across multiple worksheets ('Alpha:Delta'!).
If not possible, is there an alternative (strictly formula based)?
Thanks!