Use:

Formula: copy to clipboard
=SUMPRODUCT(MAX(COLUMN(Sheet1!A1:E1)*(Sheet1!A1:E1=Sheet2!A1)))