[B] VLOOKUP where range is values returned from another formula [/B]

I have a VLOOKUP formula where the range is a range of cells containing another VLOOKUP formula. So basically I want to search for a value in the list of results.

=VLOOKUP(B2, Sheet1!$D$2:$D$10, 3, FALSE)

On Sheet1, cells D2 to D10 contain values returned from another formula.

Is this possible, what I'm trying to do? I get a #REF! error currently.

Thanks