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
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Last edited: