Find max value with criteria and return corresponding value

[AKAvenger]

Dear Excel Guru's
I need urgent assistance.

I need to find the max value on a file number and return the corresponding customer name. My image refers. I am able to find the max value for a file number but unable to return the corresponding customer name.
Can someone help me?

 

[etaf]

I'm assuming the Max value is in E,
BUT this does NOT need E - however MAXIF is 2019 or excel 365
What version do you have


=INDEX(A:A,MATCH(MAXIFS(D:D,C:C,C2),D:D,0))

lookup the Max Date for a value.xlsx
	A	B	C	D	E	F
1	Name		File Number	Value		Name Max
2	A		1	100		G
3	B		2	200		B
4	C		3	300		C
5	G		1	400		G
6	B		2	500		B
7	C		3	1		C
Sheet1

Cell Formulas
Range	Formula
F2:F7	F2	=INDEX(A:A,MATCH(MAXIFS(D:D,C:C,C2),D:D,0))

 

[etaf]

what happens if for various file numbers they have the same Max value but for different customers?

 

[AKAvenger]

what happens if for various file numbers they have the same Max value but for different customers?

Hi Etaf,
Answer 1: Column D is the value I need to search to find max. Column E is a formula that finds the max amount based on the file number which works for that purpose but I need the customer name to be returned not the max value. I am using O365.
Answer2: I realize that this might happen, where there is the same value and different customer names, but currently I am not concerned if the formula returns whichever comes first, the number of times this occurs is rare.

I tried your suggestion: =INDEX(A:A,MATCH(MAXIFS(D:D,C:C,C2),D:D,0)) and it works. I will now apply to my main data and see if I get the desired results.