I have a table of data in a sheet (blad1.A2:I115). The first column (A) is a list of numbers that is being referenced. The last column (I) has the value I want to get returned.

This is what I tried:

=VLOOKUP(R2, Blad1.A14:I115, 9)

But it returns #N/A

R2 contains the number 1269, which should be found in blad1.A73.

Can anyone explain what I'm doing wrong?