Returning contents of cell below the one found with a vlookup

Hi,

My Excel workbook has two sheets. The first is a simple, two column sheet with a unique ID in column A and a value in column B. On the second worksheet I want to return some information from Sheet 1, using the unique ID as the vlookup.

So, in Sheet 2 I have the following formula in one of the cells:
=VLOOKUP(B2,Sheet1!A:B,2,FALSE)

This works perfectly, it returns the result I want, eg the contents of cell B46 from Sheet 1.

However, in another cell in Sheet 2 I want to return the value against the next unique ID in sequence. So if the formula above returns the value in Sheet1 B46 then I want another formula to return the value which is in Sheet1 B47.

Is there an easy way I can do this?

I hope all of that makes sense!

Perfect, thanks - the second option works a treat :D