ExcelBanter - Need Help in Excell Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need Help in Excell Formula (https://www.excelbanter.com/excel-worksheet-functions/221830-need-help-excell-formula.html)

Vijayavel

Need Help in Excell Formula

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

David Biddulph[_2_]

Need Help in Excell Formula

=IF(ISERROR(FIND("_",Sheet1!A1)),"",LEFT(Sheet1!A1 ,FIND("_",Sheet1!A1)-1))
--
David Biddulph

Vijayavel wrote:
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..

Ashish Mathur[_2_]

Need Help in Excell Formula

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

"Vijayavel" wrote in message
...
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..

All times are GMT +1. The time now is 03:05 AM.