I presume there are more of these to come? You have an entire list of numbers you want to lookup and if present put a new value in column C on that row?
The formula you want is VLOOKUP. You need to create a table off to the right where you list your lookup values in the first column and the results you want to return in the adjacent column.
M N
0000 1500
0050 2100
0100 2442
etc...
So, is you setup this table in columns M:N, you could put this formula in C1 and copy down:
=VLOOKUP(A1, $M:$N, 2, 0)
Bookmarks