I am trying to get the highest value in one column and return the
corresponding value of the same row using the following function:

=VLOOKUP(MAX(D5;D11;D17;D22;D28;D33;D38;D44);A1:D4 4;2;FALSE)

But I am receiving this error: #N/A

After checking the error, there is something wrong with the 'col_index_num'
part of the formula. This number should refer to column 'B' in my sheet.