Compare sheet 1 column A numbers with sheet 2 column A number

  • Thread starter Thread starter Not and Excel Expert
  • Start date Start date
N

Not and Excel Expert

I would like to compare the Column A, sheet 1 numbers with the Column A sheet
2 numbers and report inconsistencies in Column H sheet 2. I have 1225 rows
on sheet 1 and 1336 rows on sheet, excluding header row. Could someone help
me with the vlookup or what would work best to get this done quickly? I'm
about ready to compare number by number with search.
 
In Sheet 2 cell H2 enter this formula and copy down as required...

=IF(ISERROR(MATCH(A2,Sheet1!A:A,0)),"Not Found","Found")

If this post helps click Yes
 
I would like to compare the Column A, sheet 1 numbers with the Column A sheet
2 numbers and report inconsistencies in Column H sheet 2.  I have 1225 rows
on sheet 1 and 1336 rows on sheet, excluding header row.  Could someonehelp
me with the vlookup or what would work best to get this done quickly?  I'm
about ready to compare number by number with search.
Click to expand...

A other solution without programming and completly free :
XLComparator
http://www.xlcomparator.net
 
Back
Top