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

's Computer Specifications

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

's Computer Specifications

Hi,

You can use this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" <(E-Mail Removed)> wrote in message
news:5B84E616-D961-4E83-B7FA-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing a vba variable to a range of cells	ed	Microsoft Excel Programming	5	15th Sep 2009 05:15 PM
display text in a cell in a range of cells	Shu of AZ	Microsoft Excel Misc	1	25th Jan 2009 05:09 AM
Comparing cells written in text to cells producing text from a for	David B	Microsoft Excel Programming	1	28th Apr 2008 07:20 PM
Comparing a single cell to range of cells	BobC	Microsoft Excel Programming	2	20th May 2004 06:44 PM
Comparing a cell value to a range value and display a matched value	=?Utf-8?B?QWxiZXJ0IFNpbQ==?=	Microsoft Excel Programming	0	27th Jan 2004 04:26 AM