Using Vlookup and Offset?

I'm trying to use Vlookup to report a cell, the problem is that the cell is one row down from the reference, example:

Name Number
John
7
Jane
5

So how do I get it to report the seven when I reference the John cell, if the number is one row down and one column over?

An INDEX / MATCH should suffice, eg:

=INDEX(B:B,MATCH(C1,A:A,0)+1)

where A:A holds names, B:B values and your name of interest is in C1.