I am having trouble trying to get a formula to work that can find the Max Value in a given column range based on a partial text string that is in a cell. The data is sorted in a table, that has 10 columns. First having the name and the other 9 with different bits of info about that item. I want the formula to find all the rows that partially match the text string recorded in a cell using column 1. Then find the max value in columns 4-10 from the remaining rows.

Thanks