Calculated Field - vLookup

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by KVJS

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot table, IF function, calculated item versus calculated field	NomadPurple	Excel Discussion (Misc queries)	1	March 9th 10 03:17 PM
I want to create a calculated item based on a calculated field	Stijn	Excel Discussion (Misc queries)	1	August 25th 08 05:30 PM
Calculated Field and Calculated Item in Pivot Table	Fred Smith	Excel Discussion (Misc queries)	0	March 4th 07 08:15 PM
Pivot Table Formulas Calculated Item / Calculated Field	Vikram Dhemare	Excel Programming	2	October 10th 06 08:45 AM
pivot table formulas for calculated field or calculated item	Vicky	Excel Discussion (Misc queries)	3	June 6th 06 05:06 AM

All times are GMT +1. The time now is 12:01 PM.

Menu

About Us