ExcelBanter - Match

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Match (https://www.excelbanter.com/excel-worksheet-functions/148341-match.html)

Arturo

Match

Column A houses a series of number.
Column C does too.
Not finding quickly the correct formula to test if cell A1 has any matching
column C.

Thanks,
Arturo

Mike H

Match

Try this:-

=IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"No match","Match Found")

Mike

"Arturo" wrote:

Column A houses a series of number.
Column C does too.
Not finding quickly the correct formula to test if cell A1 has any matching
column C.

Thanks,
Arturo

Toppers

Match

in D1:

=IF(Countif(A:A,C1),"Yes","") wll give "Yes" if a match

and copy down

"Arturo" wrote:

Column A houses a series of number.
Column C does too.
Not finding quickly the correct formula to test if cell A1 has any matching
column C.

Thanks,
Arturo

Teethless mama

Match

=IF(COUNTIF(C:C,A1),"found","not found")

"Arturo" wrote:

Column A houses a series of number.
Column C does too.
Not finding quickly the correct formula to test if cell A1 has any matching
column C.

Thanks,
Arturo

All times are GMT +1. The time now is 05:44 AM.