Thanks for the quick response.

I gave it a go, it looks in concept like what I need but it has the issue of returning the greatest value in B1:B100 regardless if that particular value is associated with the value in C1. It seems to be just checking if A1:A100 has the C1 value but not using it again for the filtering.