With your data in Sheet 1 in Column A starting at cell 1 to cell 500
With your data in Sheet 2 in Column A starting at cell 1 to cell 150
On Sheet 2 enter the formula cell B1:
=IF(ISERROR(MATCH(A1,Sheet1!$A$1:$A$500,0)),"No Match in Sheet 1","Match")
Drag down 150 rows.
If there is a Match, then the word Match will appear in column B
If there is no Match, then No Match in Sheet 1 will appear in column B
Also, since your importing the data, make sure your Numbers are really Numbers not TEXT that look like numbers.
Real numbers will be Right Justified in the cell.
A simply way to insure all your numbers are numbers is to do a simple: =A1*1 this should force any TEXT to Numbers.
See how that work.
Also, Excel questions are best asked in the Office Software Forum.