Hello,
I would like to create a formula that equals one cell if a selection of
others include certain text.

For example, A1 is H, B1 is HI, B2 is HHI.

I want my formula to equals A1 if cells E8-E10 contain the contents of B1 or
B2

Thank you
Fiona

One way..

Try in say, C1:
=IF(SUMPRODUCT((ISNUMBER(MATCH(E8:E10,B1:B2,0))*(E 8:E10<"")))0,A1,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fiona" wrote:
Hello,
I would like to create a formula that equals one cell if a selection of
others include certain text.

For example, A1 is H, B1 is HI, B2 is HHI.

I want my formula to equals A1 if cells E8-E10 contain the contents of B1 or
B2

Thank you
Fiona

Try this:

=IF(SUMPRODUCT(COUNTIF(E8:E10,B1:B2)),A1,"")


"Fiona" wrote:

Hello,
I would like to create a formula that equals one cell if a selection of
others include certain text.

For example, A1 is H, B1 is HI, B2 is HHI.

I want my formula to equals A1 if cells E8-E10 contain the contents of B1 or
B2

Thank you
Fiona

Hi

If I new what you data looked like it would be easier but I tried this
A B C D E F G
1 H HI
2
3
4
5
6
7
8 HI
9 HI
10 HI =E8&E9&E10 =IF(F10=$B$1&$B$1&$B$1,$A$1,"")

Norm


"Fiona" wrote:

Hello,
I would like to create a formula that equals one cell if a selection of
others include certain text.

For example, A1 is H, B1 is HI, B2 is HHI.

I want my formula to equals A1 if cells E8-E10 contain the contents of B1 or
B2

Thank you
Fiona