ExcelBanter - #Ref error when using vlookup formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #Ref error when using vlookup formula (https://www.excelbanter.com/excel-worksheet-functions/142669-ref-error-when-using-vlookup-formula.html)

Neil

#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

Neil

#Ref error when using vlookup formula

"neil" wrote:

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

Naraine Ramkirath

#Ref error when using vlookup formula

the last number should be 1 not 2 or should your range be d5:e846?

"neil" wrote in message
...

"neil" wrote:

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

All times are GMT +1. The time now is 11:21 PM.