VLOOKUP problem

[toppman]

Hi Guys,

Underneath this table I am using =max to find the highest value in the F column, which is 13.64. My issue is this, when I am using =max I also want to find the age band that 13.64 relates to.

For example in F36 I have =max which returns 13.64. In B36 I want the age band that relates to 13.64 which would be 18-24. I want this to be dynamic so if the values change the cells automatically update to the new highest value in those columns and the band that relates to the highest value.

I hope that's clear, any help would be appreciated as i can't seem to get VLOOKUP to work.

[canapone]

Hi,

maybe

Please Login or Register  to view this content.

Regards

[toppman]

Works perfectly, thanks canapone you're my hero!

[canapone]

Ciao,

thanks for you kind feedback.

Greetings from firenze

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.