Relative reference table lookup and adjustment

Hi,

I want to be able to pass in a customer type (column headers in row 1) and a number of points (the values in B2:F14) and return the value in column A for that particular customer type. For example, for customer type 2 and 9 points, I'd want to return 72.5. For customer type 5 and 13 points, answer would be 62.5. For a particular customer type, if there is more than one answer for points (e.g., 10 for customer type 5), I'd want to return the largest column A value (e.g., 55.0).

Thanks for your help!

James


excel sample.jpg