match formula

I have an xlsx with 2 sheets. In column G of sheet 1 are a list of names, in column H I have put a column called "match". On sheet 2 is also a column (column A) full of names. What formula can I put in column H to put a 1 if the name in column G sheet 1 is also evident in the list of names on sheet 2 column A, and a 0 if it isn't evident?
LVL 3
pma111Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=sign(countif(sheet2!A:A,g2))
0
 
helpfinderConnect With a Mentor IT ConsultantCommented:
use VLOOKUP formula
if you want to have O and 1 then you can add in sheet 2 column B with 1´s and use VLOOKUP with IFERROR together - as you can see i the attached sample
sample.xlsx
0
 
pma111Author Commented:
top formula creates errors
0
 
MINDSUPERBConnect With a Mentor Commented:
See the example attached.

Sincerely,

Ed
Sample.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
It works here
Match-by-count.xlsx
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.