Try this:

=VLOOKUP(B3,INDIRECT("'"&D3&"'!B9:C109"),2,0)

Biff

"jnasr" wrote in message
ups.com...
to make it simpler, let's say I have sheet 1 and 2. On sheet 2, I have
data from cells b9 to c109. I'm trying to use the vlookup to reference
the data label in the first column of sheet 2 (column b in the array)
and lookup the data value in the second column (column c).

on the first sheet, i have the second sheet name in cell d3 and the
lookup reference in cell b3. I think Biff's suggestion may work, but I
don't know how to manipulate the indirect function. Excel's help tool
was pretty useless.

Thanks,
Joe