Google Sheets Formula Help

[nrc0710]

I need some assistance with a formula for Google Sheets. The following formula works in Excel, but not in Google Sheets. I don’t believe the “Take” formula is in sheets. Any ideas on how to find what I’m looking for based on the example below?

=TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)

 

[Fluff]

How about

=index(SORT(FILTER(C3:D10,B3:B10=G5),2,-1),1,0)

 

[nrc0710]

How about

=index(SORT(FILTER(C3:D10,B3:B10=G5),2,-1),1,0)

This returned Will & 10 instead of Mark & 39. I made the following change and it returned what I needed! Thank you for your help!

=index(SORT(FILTER(C3:D10,B3:B10=G5),2,0),1,0)

 

[Fluff]

Glad to help & thanks for the feedback.