Quote:
Originally Posted by ArviLaanemets
My advice is use a single table instead of 3 tables, like:
MinDistance, MaxDistance, Type, Plums, MinValue, MaxValue
200 250 A 2 89 92
200 250 A 3 92 94
...
450 550 E 11 100 110
...
450 550 H 11 100 110
Now your calculation will be a simple SUMIFS() formula.
|
Thanks to both Avril and Steve, but I have been sent a formulae which involves minimal changes and uses VLOOKUP, INDEX and MAPPING. Thanks anyway.