COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.

[John]

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

 

[Ashish Mathur]

Hi,

You can use this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com