vlookup function, picking up the wrong row

[superdan]

Hi,
For some reason when doing a vlookup the figure pulled into my spreadsheet appears to be from the row above.

My spreadsheet is like this

A B
1 LRTN =vlookup(a1,sheet2!A2:b50,2)


Sheet two is a long list like this

LRTL Software
LRTN Mining
LRTP Cole

Basically i thought it should say mining, however it is picking up the one above, in this example 'software'

Cheers