Index with nested match does not return expected values

Question

I am trying to get a cell to output the name of the item that is on the same row as the target cell.

This is the code I am using (D17 is relative to the row):

=index(Sheet2!C$2:C$15; match($D17; Sheet2!D$2:D$15); 0)

And this is what it outputs:

I have no idea why it's not working, and I do not know why it outputs the same item name several times. A copy of the sheet can be found here.

Answer 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(D13:D; {Blad2!D$2:D$15\Blad2!A$2:A$15}; 2; 0)))