Hi everyone,

I am have a problem with a vlookup formula or maybe it is the wrong formula all together, any way what I am trying to achieve is this:

Company Company Company
ABC DEF GHI
Plant Name/ Code Pot size Qty Rate Total Plant Name/ Code Pot size Qty Rate Total Plant Name/ Code Pot size Qty Rate Total Minimum Total Lowest Company Price
10 15 150 10 12 120 10 20 200 120 DEF

So what I am trying to achieve is to have the Lowest Company Price name in this case company DEF show when the minimum total cell in this case is 120 (This formula for minimum is no probs (=min(cell,cell,cell)).
If this is not the correct thread I apologise in advance.
Any help would be great.
Thanks
Geoff