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?
Bookmarks