finding a value in a row

[HM9000]

Hi

I have a row array with several values (A B C D E) - one in each col.. What formula should I use to check if a value exists in that given row ? e.g if I am searching for the existance of C .. the first 2 rows have it and the third doesnt. If it exists .. would like the value = 1 else 0.

<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {text-align:center;} --> </style> <table style="border-collapse: collapse;width:390pt" border="0" cellpadding="0" cellspacing="0" width="390"> <col style="width:65pt" span="6" width="65"> <tbody><tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt;width:65pt" height="15" width="65">C exists</td> <td class="xl63" style="width:65pt" width="65">Array</td> <td class="xl63" style="width:65pt" width="65"></td> <td class="xl63" style="width:65pt" width="65"></td> <td class="xl63" style="width:65pt" width="65"></td> <td class="xl63" style="width:65pt" width="65"></td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt" height="15">1</td> <td class="xl63">A</td> <td class="xl63">B</td> <td class="xl63">C</td> <td class="xl63">D</td> <td class="xl63">E</td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt" height="15">1</td> <td class="xl63">B</td> <td class="xl63">C</td> <td class="xl63">D</td> <td class="xl63">F</td> <td class="xl63"></td> </tr> <tr style="height:15.0pt" height="15"> <td class="xl63" style="height:15.0pt" height="15">0</td> <td class="xl63">X</td> <td class="xl63">A</td> <td class="xl63">F</td> <td class="xl63">G</td> <td class="xl63">H</td> </tr> </tbody></table>
thanks in advance!

 

[mikerickson]

Try something like
=IF(COUNTIF(A1:E1, "A") > 0, "A is in the first row", "it isn't")

 

[Aladin Akyurek]

Although mikerickson's answer implies this...

=(COUNTIF(A1:E1,"C")>0)+0

 

[HM9000]

Thanks for your reply both. I was able to successfully test this out and it works great.

 

[Aladin Akyurek]

Thanks for your reply both. I was able to successfully test this out and it works great.

You are welcome. Thanks for providing us feedback.