Maybe something like:

=index(sheet2!c:c,match(a1,sheet2!a:a,0)+1)

You may want to make the output of the pivottable more like a pivottable.

See Debra Dalgleish's site for some nice pictures:
http://contextures.com/xlPivot02.html

jtoy wrote:

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!

--

Dave Peterson