Locate latest cell entry in column

My brain is fried from sifting thru the vast forum trying to find a similar solution, but can't nail down a specific post to apply. Many are "close, but no cigar."

Cells B75 and C75 need to show the latest entries from the array B2:C73, respectively.
Cell D76 needs to show the latest entry from the D2:D73 array.
The correct formula result will be the data in row 66.
As game results are added in rows 67 and so forth, the results in B75, C75, and D76 will adjust to the latest entries.
I removed the formulas in columns A:D, which refer to game results from another worksheet...I'm just looking to reference the latest win-loss steak and last 10 games.

Thanks in advance!

If you delete the contents from rows 67 downwards (or get your formulae to return ""), then you can use these formulae in the cells stated:

B76: =LOOKUP("zzz",B2:B73)

C76: =LOOKUP(1000,C2:C73)

D76: =LOOKUP("zzz",D2:D73)

"zzz" is just a big text value (i.e. "larger" than those expected in your data), and 1000 is a bigger number than those in your data.

Hope this helps.

Pete

Hi, pskwaak!

You could try:
[D75] : =LOOKUP(2,1/(D2:D73<>""),D2:D73)

What is the desired result in B76 and C76? Write by hand this values, because i don't understand exactly. Blessings!

The one for C76 worked, but B76 and D76 did not ... results in a blank. Is it something to do with looking up text rather than numbers?
Thanks!

The D75 formula works! The correct answer to the formulas for B76 and C76 should reference row 66 ("L" and "3"). Using the same formula you provided for D75 also works in B76 and C76! Thanks so much for the help!