RE: Look up data in colum a and find match in colum b

[Jess]

Chris
In Colum C type =EXACT(A1,B1) it will show True or False rather than Match
and No Match.
Jess



"Chris(new user)" wrote:

> I have a sheet containing two lists of ID's e.g.
> Colum A Colum B
> abc123456 hjt456897
> hjk8966536 jk456654558
> hgg009664 jjk5566377
> The colums contain 2000 entries. I want to check if the items in colum b
> match the items in colum a. I would like excel to do this check and in colum
> c show Match or No Match e.g.
> abc123456 hjt456897 Match
> hjk8966536 hgg009664 Match
> hgg009664 jjk5566377 No match
> hjt456897 jjk hjkjhd No match
> Please help.

[stvgarner]

Try this and see if it will do what you need.

=IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),"No Match","Match")