PriceBanding2a.xlsmHi and thanks for your efforts. It is almost there now although it just needs one more adaptation. I need to be able to reference another quantity cell that changes and then resolve the price band query without having to press enter. See attached which I hope makes sense