#Ref error when using vlookup formula

N

neil

I am getting a a #Ref error with the following formula. The lookup value is
within a pivot table and the lookup range is not.

=VLOOKUP(A954,Sheet1!$D$5:$D$846,2)

Can someone please help me. Thanks
 
N

neil

neil said:
I am getting a a #Ref error with the following formula. The lookup value is
within a pivot table and the lookup range is not.

=VLOOKUP(A954,Sheet1!$D$5:$D$846,2)

Can someone please help me. Thanks
Click to expand...
 
Top