=INDEX(C1:C100,MATCH("Jason",A1:A100,0)+1)



--
Regards,

Peo Sjoblom



"jtoy" wrote in message
...
Using a vlookup formula, instead of referencing the value in the same row,
the 3rd column over, how can I reference the value in the row below the
lookup value, still in the 3rd column of the table.

In the example below, if I look up "Jason" (in A1), I want to return the
value 4 (C2). If this helps, the value I want to return is always in the
same
row as "Record Count" in column B.


A B C
Jason Sum of Amt 8,000
Record Count 4
Mark Sum of Amt 5,000
Record Count 5
Sarah Sum of Amt 6,500
Record Count 3
Glen Sum of Amt 7,888
Record Count 4
Tom Sum of Amt 2,500
Record Count 2
Becky Sum of Amt 4,700
Record Count 5


thanks!