IF cell range B2:M2 equals X then equal same as cell B1

[tsul5693]

Hi. I need a formula for the following please:

IF cell range B2:M1 equal "First", then equal cell B1, leave blank if false.

Thanks!
TSUL5693

[FDibbins]

Hi and welcome to the forum

1st, I would request that you change your thread title to something that describes your problem, not what you think you need.
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

2nd. I think you have something wrong with eth range you posted...B2:M1??

[tsul5693]

Sorry,

Range is B2:M2...

[alansidman]

Would you clarify please. You want to return the value in B1 if any cell in the range B2:M! includes the word "First". If this is what you intend then you will no doubt get a circular error as B1 is part of that range.

Edit: simultaneous posting

[tsul5693]

I need for the formulated to cell to equal the value of cell B1 if the word "first" can be found in range B2:M2

???

[Ace_XL]

Try

=IF(COUNTIF(B2:M2,"first"),B1,"")

[FDibbins]

is "first" the only word that will be in the cell, or is it part of a string within a cell?