I found the solution! I had to link to the cells from sheet "Warp ID." though, as the cells on sheet "Prod.ticket" are merged cells and it won't work with them.

Here is the formula (array formula) I'm using now:

=INDEX(G5:G100,MATCH(1,(B5:B100=B2)*(C5:C100=C2)*( D5:D100=D2)*(E5:E100=E2)*(F5:F100=F2),0))

the formula is to be entered with Ctrl+Shift+Enter