|
Not sure if I understood correctly but if you want to match Column A in sheet 1 to Column A in sheet 2 and display Column B in sheet 2 in Column B is sheet 1 then this should work:
=vlookup(highlight A2 in sheet 1, highlight all of columns A & B in sheet 2, 2, FALSE)
|