Spreadsheet: 823970d1680212400-getpivottable-function-not-working-with-grouped-range-of-cells-getpivotdata-sample
Sheet: Sheet3

Average of CF | Column Labels
Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Grand Total
2022 | 0.06443428909120168 | 0.0949680651589699 | 0.1342066719584799 | 0.1852415919181869 | 0.2264738378963034 | 0.2263967911367828 | 0.2266210656245895 | 0.1995528496345779 | 0.1589141820351272 | 0.1525098076380352 | 0.1012063709301215 | 0.1640784223730185
0.007-0.507 | 0.06702145553924257 | 0.08480331464676408 | 0.1265874116403126 | 0.1739458707379848 | 0.2072949599073457 | 0.1987309562078009 | 0.1963506170448174 | 0.1663374263446995 | 0.1358403343702078 | 0.1346134313066481 | 0.09554301339780594 | 0.1476198591285635
0.507-1.007 | 0.04322356037187687 | 0.07886292079975213 | 0.124312206499986 | 0.1731050529923973 | 0.2233110484939112 | 0.2247704253332122 | 0.2381518207267762 | 0.2004648984197883 | 0.1355763992499986 | 0.120251060043765 | 0.06933051409070085 | 0.1468741790454609
1.007-1.507 | 0.03824268048174241 | 0.08107268290457946 | 0.138692053813794 | 0.1964421917127856 | 0.2399381657488659 | 0.2693464417482617 | 0.2606246595439835 | 0.2046038379406474 | 0.1655348316068303 | 0.1621345247577327 | 0.08792393926493543 | 0.1696783596409724
1.507-2.007 | 0.06914071150691385 | 0.1051907387007833 | 0.1639426802103214 | 0.2068410505389672 | 0.2451393551191938 | 0.2665269414227747 | 0.2795127680712358 | 0.2314810381630658 | 0.1823167259327974 | 0.174325542289252 | 0.1156341523702635 | 0.1869446515015335
2.007-2.507 | 0.05913978494623656 | 0.1065476190476191 | 0.2006720430107527 | 0.2552777777777778 | 0.3100806451612903 | 0.3158333333333334 | 0.3048387096774194 | 0.2456989247311828 | 0.2306944444444445 | 0.2073924731182796 | 0.1270833333333333 | 0.2184627109158242
2.507-3.007 | 0.07794668973756849 | 0.1114931125706988 | 0.1309609583038393 | 0.1583246255660049 | 0.2094990505724655 | 0.2352875014512945 | 0.2595806507792047 | 0.2114646183750745 | 0.1448124512779685 | 0.1560856459076704 | 0.1067766747939162 | 0.1650480641558691
3.007-3.507 | 0.05940135386442225 | 0.1042068402589676 | 0.1372584928629174 | 0.2069370360175602 | 0.2704319801718348 | 0.2767402903472743 | 0.2718008556422216 | 0.2587841699776337 | 0.1883613741097018 | 0.171934636445697 | 0.1059012923523946 | 0.1934109070155457
3.507-4.007 | 0.06227435014719936 | 0.1104565728673573 | 0.1652415946827552 | 0.2138362122076191 | 0.2774246400542654 | 0.2836393260938589 | 0.2792127598934595 | 0.2143906563608337 | 0.176089474108725 | 0.1880605191782932 | 0.1149127009541493 | 0.1873765641195282
4.007-4.507 | 0.06897378805980957 | 0.125253026294693 | 0.1456070562253358 | 0.2001964085297419 | 0.2568199920350458 | 0.3176229891507669 | 0.3282669888852685 | 0.2798685782556751 | 0.2086162551440329 | 0.170590311719344 | 0.1172254956977179 | 0.2017309899997665
4.507-5.007 | 0.06662671850686976 | 0.1084145960900793 | 0.1322126060105407 | 0.1889004540562236 | 0.2345632583670269 | 0.2337808285453695 | 0.2348749057765066 | 0.2279360727651453 | 0.1815422710371717 | 0.1670407032848747 | 0.1067685755567602 | 0.1749181552105743
Grand Total | 0.06443428909120168 | 0.0949680651589699 | 0.1342066719584799 | 0.1852415919181869 | 0.2264738378963034 | 0.2263967911367828 | 0.2266210656245895 | 0.1995528496345779 | 0.1589141820351272 | 0.1525098076380352 | 0.1012063709301215 | 0.1640784223730185
 | GETPIVOTDATA(data_field, pivot_table, [field1, [NAME], [NAME], item2], ...)
lookup [NAME] | Find result | MONTH
0.007 |  | 7
0.507 |  | 3
4.007 |  | 9
3.7 |  | 6
2.3 |  | 4
2.507 |  | 5
GetPivottable function not working with grouped range of cells
I have a pivot table set up with field1 rows grouped into 10 buckets that have a low and high range separated by 0.5.
I would like to use getpivotdata function to look up data values using the item1 value that will fall in between the low and high range of field1 value called "nameplate"
In the sample, the getpivotdata functions works when [NAME] is equal to the field1 low or high value but does not work when the value falls in between the two values.
Any recommended solution would be appreciated.
Thank you