Search and Verfiy if data exists
Posted on 2011-04-20
I have two worksheets in an Excel workbook. Sheet1 has data of capital assets send by Finance. Some assets were disposed and my database has recorded this information. So I ran a report to find all the disposed assets which is now Sheet2.
I want a formula that can search and verify the tag numbers (which is in sheet1, column C) with tag in Sheet2, column A
Any advise to resolve this will be appreciated.