#REF error when using getpivotdata within a vlookup

[dcgrove]

Hello, I am trying to use the formula below to reference a cell in a pivot table and it is failing to a #REF error. I am sure it is the getpivotdata sub functions that is causing the error as this is my first attempt at using them. Can someone tell me what I am doing wrong?

=VLOOKUP(RIGHT(GETPIVOTDATA("Values",A10),LEN(GETPIVOTDATA("Values",A10)-8)),newvio,2,FALSE)

The file is too large to upload here with the pivot table included so I have uploaded it to another server.

http://www.4shared.com/file/18417360...data_test.html

Thanks!

[Huron]

I downloaded your file (eventually) but it doesn't seem to have a pivot table in it. There are columns which look as if they have been copied and pasted from a pivot table but are now values so you can discard the GetPivotData part of your formula and just use

Please Login or Register  to view this content.