How do you use Max match in Excel?

I'm trying to figure out how to apply the Max match technique in Excel. I've heard it's useful for certain data manipulation tasks, but I'm not sure how to go about using it within the Excel environment.