I'm trying to use OFFSET and MATCH since VLOOKUP doesn't go right to left--and I am unable to redesign my table.

Sheet 1
col a: car type
col b: plate number

In another sheet I want to match a cell in which I type a plate number (let's say B4)

In the next cell (B5) I want to: =MATCH(B4, Sheet1!B:B, 0) to find that plate number in Sheet1, Col B.

Then I want to OFFSET one cell to the left to read the car type.

How do I get OFFSET to realize I want to move around based on the location, on the sheet, that MATCH found?

Thanks