ExcelBanter - searching columns for the same value

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - searching columns for the same value (https://www.excelbanter.com/setting-up-configuration-excel/181799-searching-columns-same-value.html)

Diggs

searching columns for the same value

I have a cloumn of values and I want to search another column of values and
have a "yes" or "no" yeild if the value in column A is found in column B. If
there a formula that can help me with this?
Thanks

Gary''s Student

searching columns for the same value

Use COUNTIF()

Let's say we want to know if the value in A7 is found anywhere in column B.
In an un-used cell (in a column other than A or B) enter:

=IF(COUNTIF(B:B,A7)0,"YES","NO")
--
Gary''s Student - gsnu200776

"Diggs" wrote:

I have a cloumn of values and I want to search another column of values and
have a "yes" or "no" yeild if the value in column A is found in column B. If
there a formula that can help me with this?
Thanks

All times are GMT +1. The time now is 10:42 PM.