Validate for one of multiple criteria in a row

[gwstudent]

This seems so simple yet my formula isn't working - so I must be going about this the wrong way.

I have a row of data from column B to column Z:
A, B, C, D, E, F, G, H...

If the row contains an "A" or an "H" (or any other value) I would like to simply show a "1" in the current cell - A1. My formula below seems fairly straightforward but I get #N/A. Any help would be appreciated


=IF((OR(MATCH("A",$B1:$Z1,0),MATCH("H",$A1:$Z1,0))),1,"")

 

[chirayu]

Formula is made for A & H only. Change as required

=IF(OR(COUNTIF($B1:$Z1,"A")>0,COUNTIF($B1:$Z1,"H")>0),1,"")

 

[gwstudent]

Chirayu -
You are a champion and a scholar. Thank you very much!

 

[Xiq]

Hi gwstudent,

Here is another solution.

=(SUMPRODUCT(--({"A";"H"}=B1:Z1))>0)*1

 

[gwstudent]

Xiq - that worked too. Two totally different solutions but with the same result. I never would have thought to use either approach. Thank you for your input.