Retrieve value from cell based on Match Formula. Help needed

[claybwagner28]

I have a formula where I retrieve the highest transaction entry for sales. The formula is =MAX(‘Sales”!E4:E544).
It returns the value I need which is $28,765.

4 cells to the left of “28,765” is the user ID. (Column A)

I am looking for a formula to retrieve the cell 4 cells to the left (Column A) of the match formula.
Thanks for any help!

Clay

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1		Max	Name
2		28765	Name2
3
4
5
6	Name1				12345
7	Name2				28765
Sales

Cell Formulas
Range	Formula
B2	B2	=MAX(Sales!E4:E544)
C2	C2	=INDEX(Sales!A4:A544,MATCH(B2,Sales!E4:E544,0))

 

[claybwagner28]

Thanks!!!!!

 

[Eric W]

Happy to help!