i have the following formula in a table of 5 rows and 4 columns
=INDEX($U$8:$U$27,SUMPRODUCT(($V$8:$Z$27=$L17)*(ROW($U$8:$U$27)-ROW($U$7))))
which returns the row detail from a pivot table when linked to L17 ( largest number in PT )
The issue i have is some of the values in the L column are the same which in turn returns a #REF from the above formula when i know the cell should populate with the column header from the pivot table
How can i resolve this?Capture.PNG
Bookmarks