Look up excel

On sheet 1 I have column L with thousands of zip codes.

On sheet 2 I have column A with about 70 zip codes.

On sheet in column AX, I would like to say "Yes" if the zip listed in column L is in the list on Sheet 2 Column A.

Any ideas how to do this? Trying to use "Match" but not working. Thanks!
cansevinAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
This is for row2 and copied down

=if(counta(sheet2!A:A,A2),"yes","")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.