PVR101
asked on
vlookup
how can I do a vlookup using data from a pivot table?. MAX function seems to work ok but unable to resolve for vlookup after a copule of attempts - see sample sheet. Basically want to return the corresponding (group) value for determined max value in table. I believe getpivot data function should work but obviously current formula wrong.
ee-PIVOT-TABLE-VLOOKUP.xlsx
ee-PIVOT-TABLE-VLOOKUP.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure but i think you cannot use GETPIVOTDATA for Row Labels Data
ASKER
OK thanks
ASKER