I am trying to use the vlookup function and it is returning the value in the
cell in the row just above the appropriate value in the table I am searching.

For example, when my lookup_value corresponds to A3 (in the table below),
the function is returning B2:
A1 B1
A2 B2
A3 B3
A4 B4

Just in case this matters, the array has been copied from Access (but it's
in an Excel worksheet). Also, the values in the lookup column are in 2 forms
(#1 form 123456, #2 form 234-567). I have tried converting everything to
text and to general numbers but it doesn't seem to help.

Any help would be appreciated.
Bran