vlookup e.g.

Line 1 (Table)(Col A)REF123(ColB)245
Line 2 (Table)(Col A)REF123(ColB)246
Line 3 (Table)(Col A)REF123(ColB)247 and so on..

On column C(above) i need to return column b from the array.(below)

Line 1 (Array)(Col A)REF122(ColB)243
Line 2 (Array)(Col A)REF123(ColB)244
Line 3 (Array)(Col A)REF123(ColB)245

when i do a vlookup i have to use column A for the data but when i ask for
column b to be returned it dosent match (Line 1 on Table pulls through line 2
on array when i need line 3 which is the correct match.

Is it possible to do this?