Hi

I would like to search across a number of rows in a worksheet and then match against two columns.

e.g.

Column B Column C

test 10


I would like the function to match against all rows that match against "test" in Column B and then work out which cell in Column C has the highest value

I have looked in excel help but it I cannot find anything that shows me an example of what I am trying to do

I would appreciate any help on this

Thanks