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

Docgero wrote:

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" wrote:

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.



Docgero wrote:

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


--

Dave Peterson