# VLOOKUP and OFFSET

C

#### CEG

I have two worksheets.

SHEET1:
A B
1.1
1.2
1.3
1.4

SHEET2:
A
1.1
apples
1.2
bananas
1.4
grapes

I want a formula in Column B of sheet1 to return the values below the
corresponding value in column A of sheet2.

I wrote a lookup formula to find the corresponding value: VLOOKUP(A2,
WKSHT2!A1:A5,1,FALSE)

And I wrote an offset formula to find go down one row:
OFFSET(WKSHT2!A1,1,0,1,1)

I feel like there should be some way to replace "A1" in the second formula
with the first formula, but I cannot get it to work.

=OFFSET(VLOOKUP(A2,WKSHT2!A1:A5,1,FALSE),1,0,1,1)

The real worksheet is obviously much larger and more complicated than my
sample, but if I can just get the syntax right, I think I can work out any
other issues.

T

#### T. Valko

Try this:

=INDEX(Sheet2!A2:A7,MATCH(A2,Sheet2!A2:A7,0)+1)

C

#### CEG

Thank you...perfect!
--
CG

T. Valko said:
Try this:

=INDEX(Sheet2!A2:A7,MATCH(A2,Sheet2!A2:A7,0)+1)

T

#### T. Valko

You're welcome!

--
Biff
Microsoft Excel MVP

CEG said:
Thank you...perfect!