How do we match two workbooks by row?
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 |
All times are GMT +1. The time now is 06:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com