View Single Post
  #1   Report Post  
KVJS KVJS is offline
Junior Member
 
Posts: 2
Default Calculated Field - vLookup

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