Forum Discussion
Solved
Find words automatically in an Excel sheet
I have an excel sheet including many words. Is it possible to see automotically these words including or not in a different excel file. For example, The words in Sheet 1 are marked automatica...
Hi,
You can do this by modifying the formula this way:
=AND(ISNUMBER(MATCH("*"&A1&"*",Sheet1!$A:$A,0)),NOT(ISBLANK(A1)))So that it will match the word in sheet 2 with the word in sheet 1 even if the word in sheet 2 is included inside any cell of column A in sheet 1.
Is it possible to use this formula like below? For example; Peugeot Motor Company is written in sheet1 but there is only Peugeot written in sheet2, it can be a formula works at that situation?
Hi,
You can do this by modifying the formula this way:
=AND(ISNUMBER(MATCH("*"&A1&"*",Sheet1!$A:$A,0)),NOT(ISBLANK(A1)))So that it will match the word in sheet 2 with the word in sheet 1 even if the word in sheet 2 is included inside any cell of column A in sheet 1.