Problems with index match

I am having a problem with the index max function in this table, I am trying to find out Nathan foster sales of eureka instead of using index match or v lookup, can anyone help?