Hi

The problem is caused because many numbers cannot be represented accurately
in binary.
If you use the Round function, then the Vlookup will work

=VLOOKUP(ROUND(A54-100,1),$A$1:$B$25,2,0)

Note: I assume the ,1,0 in your posted formula was a mistype, as ,1 would
have returned the number in column A not the value of Tomatoes from column
B.