Alternative to MAXIFS when criteria range is not same size as min range

[Melimob]

Hi

I'm basically looking for a VLOOKUP where it would have multiple hits but only to return the MAX hit value.
I thought MAXIFS was my saviour however my ranges aren't the same sizes.

Any ideas on what else I could try please?
Many thanks

 

[Toadstool]

Hi Melimob,

Can you give a sample of your data with a worked example?