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"