RUSSELLCLEWS
New Member
- Joined
- Jan 29, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi there. Please can anyone help? Im trying to display the work "Blue" in a cell if two other cells say the word "Standard" I have this formula but cant seem to get it right?
=IF((AND(ISNUMBER('SEARCH'("BLUE",H8 "BLUE",I8)),"STANDARD","")
Can anyone correct me on this?
Thanks in advance..
=IF((AND(ISNUMBER('SEARCH'("BLUE",H8 "BLUE",I8)),"STANDARD","")
Can anyone correct me on this?
Thanks in advance..