If cell contains text display another cell

**The.don** · 03-12-2014, 01:01 AM

I need a formula.

A1 1,2,3
A2 4:00

B1 4:00

I need B1 to display A2 if A1 contains 1.

**:) Sixthsense :)** · 03-12-2014, 01:04 AM

In B1 Cell

=IF(A1=1,A2,"")

**The.don** · 03-12-2014, 01:08 AM

Thanks for that.

Now if A1 contains multiple numbers ie 1,3,4 etc

How would that look?

**:) Sixthsense :)** · 03-12-2014, 01:13 AM

Originally Posted by The.don

Now if A1 contains multiple numbers ie 1,3,4 etc

Find() Case Sensitivity....

=IF(ISNUMBER(FIND(1,A1)),A2,"")

Or

=IF(ISNUMBER(SEARCH(1,A1)),A2,"")

Or

=IF(COUNTIF(A1,"*1*"),A2,"")

**FDibbins** · 03-12-2014, 01:15 AM

=IF(or(A1=1,A1=2,A1=3),A2,"")

**:) Sixthsense :)** · 03-12-2014, 01:19 AM

Or

=IF(OR(A1={1,2,3}),A2,"")

**FDibbins** · 03-12-2014, 01:25 AM

Nice Six, I always forget the {} option

**:) Sixthsense :)** · 03-12-2014, 01:28 AM

Originally Posted by FDibbins

Nice Six, I always forget the {} option

Me too...

But not sure whether that Array {} combination suggestion will work for the OP, since OP running in Open Office

**FDibbins** · 03-12-2014, 01:31 AM

I think the other member we are both helping, is using OpenOffice, not this 1

**:) Sixthsense :)** · 03-12-2014, 01:32 AM

Oopss... I confused it with another OP's version.

Please ignore Post #8 version comment.

**:) Sixthsense :)** · 03-12-2014, 01:33 AM

Originally Posted by FDibbins

I think the other member we are both helping, is using OpenOffice, not this 1

Yes, exactly and sorry for mis-interpreting the OP's name and the office versions....

Re: If cell contains text display another cell