Compare sheet 1 column A numbers with sheet 2 column A number
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
---------------
Jacob Skaria
"Not and Excel Expert" wrote:
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.
|