Im not that great with excel formulas so could do with some help if anyone could.
Lets say in column A there could be any number between 1 and 52
In column B there will be some text, for this lets say hello, goodbye, happy ,sad.
The cell with the formula in (lets say E1) I need it to look at the data in column A & B and for this example lets say I want E1 to return true if any of that data in A = 4 and the B cell next to it contains hello.
Any help appreciated.