An easy IF question

[akparasite]

Does anyone know how to write an IF statement based upon a search of specific text values within a range?

For example, I've tried:

=IF(B10:M10="TextValue1","TextValue2","TextValue3")

...but it doesn't work. Any help would be appreciated. Thanks!

 

[Aladin Akyurek]

On 2002-08-26 12:09, akparasite wrote:
Does anyone know how to write an IF statement based upon a search of specific text values within a range?

For example, I've tried:

=IF(B10:M10="TextValue1","TextValue2","TextValue3")

...but it doesn't work. Any help would be appreciated. Thanks!

Is it not...

=IF(ISNUMBER(MATCH("TextValue1",B10:M10,0)),"TextValue2","TextValue3") ?

 

[akparasite]

Thanks Aladin! Right on target!