match formula

Posted on 2014-01-27
Medium Priority
Last Modified: 2014-01-27
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?
Question by:pma111
LVL 43

Accepted Solution

Saqib Husain, Syed earned 668 total points
ID: 39811816
LVL 19

Assisted Solution

helpfinder earned 668 total points
ID: 39811817
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

Author Comment

ID: 39811835
top formula creates errors
LVL 19

Assisted Solution

MINDSUPERB earned 664 total points
ID: 39811849
See the example attached.


LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39811852
It works here

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”.  It also suggests the various solutions to fix the problem.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question