Forum Discussion
Solved
Find the words automatically please help!!
Hi, I have words in the excel sheet attached and I need to find the rows including these words in a different excel sheet. At the pictures below, I chose a random word(BARSAN). For example, ...
Anil, when it'll be
=IFNA(INDEX(Sheet2!$A$1:$A$10,MATCH(1,INDEX(SEARCH(A1,Sheet2!$A$1:$A$10),0,0),0)),"")
(regular formula)
Hi Anil,
That could be array formula
=IFNA(MATCH(1,INDEX(SEARCH(A1,Sheet2!$A$1:$A$10),0,0),0),"")
Sergei first thanks,
Is it possible to see the original word(such as C column) in sheet2 instead of its row number?