I know how to find a max value....
=MAX(A1:A65535)or whatever cells I'm searching
when it returns the max value I need to have it return the column next to it...
A1=503 (my max value)
and I want it to return the value in B1