How do we match two workbooks by row?

A

Alfred

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.
 
D

Dave Peterson

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.
 
Top