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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top