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
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