Match function for multiple columns

[grkchakri]

Hi All

I have a table with 20 columns and some 20 rows out of which i need to find a maximum revenue / highest number along with the employee name

when i am using index and match function i am stuck at array parameter in the match function since i dont know in which column the
largest value would as it could be anywhere in 20 columns.

I tried to use sumproduct but i guess if the same value is duplicated in the table i guess it would give incorrect results.


how do we overcome array parameter in a match function when i dont know the value to search is in which column

Thank you all