Thread: #Ref error when using vlookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil Neil is offline
external usenet poster
  
Posts: 173
Default #Ref error when using vlookup formula
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
Reply With QuoteReply With Quote