Match data of two identical strings in two separate spreadhseets
I have two excel spreadsheets, where I want to search from both having same
ID, which looks like this, it was originally a text, and I converted all spaces and dashes into zero spaces : "097 0001-006-00". I want to compare both the files having the rows with same ID, that they have same data in other records pertaining to that ID. Something like this: For ID="097 0001-006-00" of cell "A4" search all the records in the other spreadsheet and find the record containing same ID, and then compare other records cell by cell between both files, if they are same return "SAME" else "NOT SAME", if the similar ID is not found, return "RECORD NOT FOUND" |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com