Supposing your range is C4:d14 try =INDEX(D4:d14,(MAX((C4:C14=$C$4)*ROW(4:14))-ROW(4:14)+1))

This is an array formula that should be committed with Ctrl+Shift+Enter

Attached Files

CheckMax.xlsx (9.1 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post