View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by KVJS View Post
Getting error message "References, names and arrays are not supported in pivot table formulas"
When entering vLookup in a pivot table calculated field.
Example:
Name: TblLu
Formula: =vlookup(Re_Num,newrates,34,false)

Please help.
Thanks,
Ken
Hi Ken,

Is "Re_Num" in your workbook a single cell or a range of cells?