What formula can I use to compare items in two columns

[Guest]

I have two columns of data in seperate spreadsheets. I want to compare the
data in one column with data in the other. If there is a match I want it
noted in some way. If thre is no match I want that noted as well.

 

[Dave Peterson]

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.

 

[Guest]

Thanks Dave. I did not get the desired results expected.

Perhaps I didn't explain properly what I was trying to accomplish. As
mentioned I have two spreadsheets. I have the same type data (item numbers)
in columns in each sheet. I want to look at the universe of items numbers in
column 2 sheet 1 and see if there is a match on sheet 2 column 2. This will
be an item for item check.

 

[Guest]

Dave,

I altered your formula slightly and it works. Here is what I did.

=ISNUMBER(MATCH(B5:B1170,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

works perfectly.

Thanks again.

Docgeo

 

[Dave Peterson]

I was too lazy to point at another workbook. Glad you got it working.

But I would have guessed you wanted this version:

=ISNUMBER(MATCH(B5,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

And drag down

Dave,

I altered your formula slightly and it works. Here is what I did.

=ISNUMBER(MATCH(B5:B1170,'[Book Order - ALPHA.xls]Master List'!$A$2:$A$720,0))

works perfectly.

Thanks again.

Docgeo

You can use an adjacent column of formulas:

=isnumber(match(a1,sheet2!a:a,0))

If you see True, there's a match. False means there isn't.