I attached an example book because on "paper" is kind of hard to explain.
But in the workbook you see on first tab some sort of table.
In this case it is an overview of the lowest 3 outcomes in the data (with a SMALL formula).
The data is on the 2nd tab.
My problem lies within values that are in the data multiple times.
In this case 180 is 2nd lowest and 3rd lowest.
But 1 is in week 17 and the other in week 18.
Also 1 week the name is Ceriel and the other week Rene.
But now I am only getting twice week 17 (using a index match formula) en twice the name Ceriel (vlookup)
Can anybody give the correct formulas to have more control on the name and the week in case a value occurs multiple times?
Bookmarks