VLOOKUP Find item, move down one row and do the vlookup.

**nbardram** · 03-02-2012, 10:12 AM

Hi All,

Is it possible to use VLOOKUP to find the item you want, but instead of taking the value next to it, you want it to go down one row and take that value?

Like this:
in A1:B4
Ice
Ice cake
Ice frosting
Ice water

so my vlookup is:

=VLOOKUP("Ice";A1:B4;2;FALSE) This gives me 0, but I want it to give me cake as a result.

Thanks a lot!

**darknation144** · 03-02-2012, 10:14 AM

trying looking at =HLookup()

=HLOOKUP("Ice",A1:B4,2,FALSE)

If you want it just to say cake instead of Ice cake:

=MID(HLOOKUP("Ice",A1:B4,2,FALSE),4,LEN(A2)-3)