Hi,
I have a list of keywords in Sheet A (2000 rows) and I have a sheet B (column B), where I want to highlight Column B or get YES/NO (in nearby column D) if the cell of column B contains any keyword.
For example - Column B cell contains "30secondMBA.com" and I have a keyword "MBA".
If I use ISNUMBER function, it will be insanely huge which doesn't seem worthy. Please please help me, I have to prepare this sheet today
I have a list of keywords in Sheet A (2000 rows) and I have a sheet B (column B), where I want to highlight Column B or get YES/NO (in nearby column D) if the cell of column B contains any keyword.
For example - Column B cell contains "30secondMBA.com" and I have a keyword "MBA".
If I use ISNUMBER function, it will be insanely huge which doesn't seem worthy. Please please help me, I have to prepare this sheet today

Last edited: