Need Help in Excell Formula

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..
 
A

Ashish Mathur

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
 
Top