Need Help in Excell Formula

  • Thread starter Thread starter Vijayavel
  • Start date Start date
V

Vijayavel

HI All,

we have some data like given below in Sheet1.

Column 1

118712_PE907 - Business In a Box.


In Sheet 2 like given below

Column 1

118712


We need the help in that, it has to search that data in Sheet 1
whether it is available or not?..

Please help on this..
 
Hi,

Try this array formula (Ctrl+Shift+Enter)

=IF(ISNUMBER(MATCH(TRUE,ISNUMBER(FIND(A2,Sheet1!A2:A3)),0)),"Yes","No")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top