Simply verify data in different columns

[jeepnfl]

Hey all,

I just need a formula that will verify that a unique value in column S is also listed in column A or B. Column S is my master list of codes and my regional codes are listed in columns A and B. I just need a true or false next to my master list verifying that code is also listed in A or B as a regional code.
Thanks,
Randy

 

[ChrisM]

=IF(COUNTIF($A$17:$B$20,H17)>0,"TRUE","FALSE")

Where A17:B20 is the total range of both columns A and B, and H17 is the value you want to check for.

Or you could split it up and check column A and B seperately

 

[jeepnfl]

Worked great. Thanks for you help!