View Single Post
  #4   Report Post  
Harald Staff
 
Posts: n/a
Default

MATCH has an optional third argument Match_type which goes after that comma.

HTH. Best wishes Harald

"George" skrev i melding
...
I'm curious to know and wondering if somebody could please
explain why the comma near the end of this formula does
not return an 'entered to many arguments' type of error
message? The formula gives the same result in my work with
or without the , before the ))

INDEX($A$1:$F$1,MATCH(LARGE(A7:F7,2),A7:F7,))

TIA