How can I look up max of one colume and display the colume to the.

[Guest]

I need to find the max value out of one colume and display the value of the
colume to the left of the max value.

 

[Dave Peterson]

something like:

=index(A1:A99,match(max(b1:b99),b1:b99,0))

 

[Aladin Akyurek]

Since it can be excluded that there can be multiple instances of the max
value and therefore multiple associated values, try:

http://tinyurl.com/64mz3