Solved: Left Lookup

[Grantx]

Please refer to attachment.

I have tried numerous suggestions from various web sites buy none work. Maybe someone here could make a sugestion.

Column A contains ever changing random values (hence, cannot be sorted). Column B values are fixed.

I need to determine the maximum value in A1:A10 and return its corresponding value from B1:B10. The figures have to stay in their respective columns (hence no vlookup).

Any suggestions greatly appreciated.

Grant.

[figment]

this function is working for me

=VLOOKUP(MAX(A1:A10),A1:B10,2,FALSE)

give it a try

[Grantx]

Figment,

Thank you for the suggestion. Seems to work and, against conventional wisdom, it's a =vlookup.

Before I can regard this as solved it will need running when the values are constantly changing (Thursday am).

I've been using =LOOKUP(MAX(A1:A10),B1:B10) but the results were erratic. However, all other solutions never worked.

Will keep you informed.

Thanks, once again.

Grant.

[asingh]

Hi,

Attached is a sheet which simulates column A values changing..and returns the corresponding value from columns B which are fixed. Use F9 to refresh it....!

regards,

asingh

[Grantx]

Asingh,

I'v also put yours on my sheet for testing. The conditional format feature is a simple but neat touch.

Thank you.

Grant.

[Grantx]

Gentlemen,

Both worked fine. I chose one at random.

Thank you to you both.

Grant.