Excel - Match Values in 2 Columns

Asked Jan 18 '16 at 22:29

Active Jul 17 '18 at 00:07

Viewed 89 times

-1

Consider the Columns A and C, where the values in C can be found in A.

How do I get a match where the following conditions are met?

If a value of C is found in A, it will print a 1.
If no matches are found, it will print out 0 in column B.

edited Jul 17 '18 at 00:07

Grant Miller

27,532
16
147
165

asked Jan 18 '16 at 22:29

czmhdk

29
2

Have you tried anything? Google? A book? A tutorial? An online course? An on-site course? – Amit Jan 18 '16 at 22:36
Have a look at VLOOKUP – tigeravatar Jan 18 '16 at 22:39
`=IF(ISERROR(VLOOKUP(C1,A:A,1,FALSE),0,1)` – Scott Craner Jan 18 '16 at 22:51

1 Answers1

0

This worked for me

=IF(COUNTIF($J:$J,H152)=0,"0","1")

answered Jan 19 '16 at 02:05

czmhdk

29
2