workbook 1
6 48 book $45
6 50 book $50
8 52 book $48

workbook 2
6 50 book $50

I want to know workbook 2's row exists on workbook 1 and then return True or
False.

In an empty cell in worksheet2 (in workbook2???):

=isnumber(match(b2,[book1.xls]sheet1!b:b,0))

Assuming that column B holds the key id for that book.

Alfred wrote:

workbook 1
6 48 book $45
6 50 book $50
8 52 book $48

workbook 2
6 50 book $50

I want to know workbook 2's row exists on workbook 1 and then return True or
False.

--

Dave Peterson