How to calculate equation with minimum, maximum and middle number by row?

There are three columns: A, B and C.

Each column contains different numbers in every row.

I need a formula for the following:

[5*(the highest of A1,B1 and C1)] + [3*(the smallest of A1, B1 and C1)] + [2*(whatever the remaining, middle number is out of A1, B1 and C1)]


Also, columns A, B and C will be referred to with INDEX:MATCH, not their direct letter reference as the columns they're in change every spreadsheet.


Longer, more specific version:

[5*(Highest of INDEX(3:3,MATCH("Column 1",$1:$1,0)), INDEX(3:3,MATCH("Column 2",$1:$1,0)) and INDEX(3:3,MATCH("Column 3",$1:$1,0)))]+[3*(Lowest of INDEX(3:3,MATCH("Column 1",$1:$1,0)), INDEX(3:3,MATCH("Column 2",$1:$1,0)) and INDEX(3:3,MATCH("Column 3",$1:$1,0)))]+[2*(Whatever the remaining, middle number is out of INDEX(3:3,MATCH("Column 1",$1:$1,0)), INDEX(3:3,MATCH("Column 2",$1:$1,0)) and INDEX(3:3,MATCH("Column 3",$1:$1,0)))]

Try

=SUM(MAX(A1:C1)*5,MIN(A1:C1)*3,LARGE(A1:C1,2)*2)
or
=SUM(MAX(A1:C1)*5,MIN(A1:C1)*3,SMALL(A1:C1,2)*2)

Adapt accordingly for the INDEX / MATCH

or =SUM(MAX(A1:C1)*5,MIN(A1:C1)*3,median(A1:C1)*2)