Hi,

You can use this

IF(ISNUMBER(SEARCH(F32,F30,1)),"text to display","")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" wrote in message
...
Hi
I am working on two sheets. the one sheet is used to update account
numbers
and is generated from another program. I need a function to find text from
a
range of cells. e.g. searching for BGA158/0002S from
AJB254/0002T,BGA158/0002S,DEG536/0002T; IF FOUND FROM THE RANGE OF CELLS
IN A
SHEET MUST DISPLAY ON THE ANOTHER SHEET