Hi. I'm trying to retrieve a cell value from one sheet to another where it looks up the ID# and retrieves the Score. However, I want it to retrieve the most recent Score, because the sheet it is retrieving from is a historical record with many different scores assigned to that ID# over time. Could someone help me with the formula? Thanks!
Help Article Resources
Check out the Formula Handbook template!