Struggling with a lookup that returns the last non zero value from a row

Hi, first post here so I apologize if my terminology is bad.

Basically on Sheet 1 I have a cell that contains a name that is chosen from a drop down box (cell D6). We will call this 'person A'.
On Sheet 2 I have a table that in column A has all the names of possible people. Columns B+ have an ELO rating (a number value that changes as they play more matches) and these are all individual to the person in column A. (eg B = ELO 1; C = ELO 2; D = ELO 3 etc)
However, I only want to return the last value as that is the current rating. My issue is that this is a different column for each person as each person will have played a different amount of times.

To summarize;
Cell D6 on Sheet 1 is the name
Column A:A on sheet 2 is the list of names
Column B:B+ on sheet 2 is a number value assigned to each person from column A
I wish to return the last value for the person whose name is in D6.


I have tried using tutorials of Index, match and different lookups however I have been unsuccessful so far - Probably because I'm a beginner and have made silly errors. I also tried using long formula that includes 'small'. Found this confusing however.

Any help would be hugely appreciated.

Thanks


[Update: Thank you for solving this ALiGW - Massive help and worked first time. Thanks.]

This formula returns the last non-zero entry on a row:

=LOOKUP(2,1/(A2:ZZ2<>0),A2:ZZ2)

It would be so much easier if you provided a sample workbook.

This in D3:

Please Login or Register  to view this content.

Make the ranges as wide as you need.

I see in the meantime this has been marked as solved. Was it my solution or one you found elsewhere?

Well, some feedback would have been courteous.

You're welcome. You did successfully mark the thread as solved, but it is always nice to confirm that the solution offered has worked or that you have solved it yourself. Leaving the thread hanging is a little bit discourteous.

This forum is manned by volunteers who are human beings helping out for free in their spare time. It's not a paid 'service'.

No problem.