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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
List all tables, including document structure 0
Two columns : Continuous two columns vs Parallel two Column 1
Populate a table based on check box status 2
Need help with average/lookup formula 2
Merging from an Excel file with graphics 1
Match and delete rows on two different sheets from reference numbers 4
need help with function 4

Top