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
|