Can OFFSET work across worksheets?

[rcane]

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

[Carim]

Hi,

For a susbtitute to vlookup(), the combination you need is Index() Match().

Both functions do accept sheet name references ...

[rcane]

Hi,

Do you mean Index(match())?

[rcane]

Ah, i got it.

syntax error, as always.

I was using the MATCH as the reference, instead of the name of a column of data. nice fix.

Thanks!

[Carim]

Glad you fixed your problem

Thanks for the feedback