Hi, I might be explaining this poorly.
I have a column with countries and a column with staff level. On a separate tab I have a pivot table of rates for each country/staff level. Can I create a formula that says, if this country and this staff level, then the correct rate will pull from the pivot table?
=GETPIVOTDATA("Rate",PT!$A$3,"Country",A2,"Staff Level",B2)
Where countries are in A and staff levels in B, and the Pivot Table is on sheet PT starting in A3, and your data fields are named "Rate", "Country", and "Staff Level"
Other formula solutions depend on your Pivot Table settings.
Bernie Deitrick
Excel MVP 2000-2010
you could use a vlookup or index/match with the pivot table - only issue maybe if you refresh the pivot table and it changes range
can you attach a sample spreadsheet
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks