In the following table
image2.PNG
i have the following formula ( Highlighted )
=INDEX($U$7:$U$22,SUMPRODUCT(($V$7:$Z$22=$L20)*(ROW($U$7:$U$22)-ROW($U$6))))
$L20 is the value in column 4
This is to extract the relevant row title from a pivot table based on the value in column 4 ( which searches the pivot table for the X ranked value , in this case the 4th )
From the image you can see that in column 4 i have two equal values and the row return in column 3 is #REF
what do i need to add to the above formula so it will pick up the correct row return? or do i need a different formula vlookup maybe?
Many thanks
Bookmarks