Excel 2007 : How to Lookup last occurence of name in column

[neil40]

Hi

I have a list of names that repeat - 96 rows in all - in column R
In Column U the last occurence of the name in column R will have a numeric value
All names (22 in total) appear in column V

Here is what I want to achieve
In Column AN, I want to reference the name in column V, then lookup the last occurence of this in column R and return the number associated to this that is in column U

Any assistance would be most appreciated.

Thanks
Neil

[NBVC]

Try

=Lookup(2,1/($R$2:$R$97=V2),$U$2:$U$97)

adjust ranges to suit and copy down.

[neil40]

NBVC - many thanks for this, it's just what I needed.

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[neil40]

romperstomper

I have done this. Question - why have you removed the quoted section of my reply to NBVC?

[NBVC]

Quoting entire posts is usually unnecessary clutter to the thread and to the database. You should only quote posts if it is not obvious who you are responding to within the thread or if you want to quote a specific part of a post in order to emphasize or direct you reply/comment to that specific part of a person's post.

Moderators will remove the unnecessary quotes as they are discovered.

Please just use the Post Reply instead of Quote.

[neil40]

I see your point, though it wasn't like it was a huge section that I quoted.

I make the point of replying with quotes on forums, as it annoys the hell out of me when people don't and it's hard to see who replied to what.
OK, in this case it was obvious, but I just make it a habit.

[NBVC]

Each forum has it's own rules and regulations.... we try to stick to ours