PDA

View Full Version : Solved: Left Lookup



Grantx
11-14-2007, 03:08 PM
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
11-14-2007, 03:37 PM
this function is working for me

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

give it a try

Grantx
11-14-2007, 03:57 PM
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
11-14-2007, 05:17 PM
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
11-14-2007, 06:14 PM
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
11-15-2007, 12:02 PM
Gentlemen,

Both worked fine. I chose one at random.

Thank you to you both.

Grant.