Looking up a price band?

Hi

I am trying to look up a price band based upon a quantity?

The bandings are listed below. I need to be able to return the correct price band based upon the number of users.

For example if the number of users cell showed 21 then the price band should show N. Your help would be gratefully recieved

A 1-1
B 2-2
C 3-3
D 4-4
E 5-9
K 10-14
M 15-19
N 20-24
P 25-49
Q 50-99
R 100-149
S 150-249
T 250-499
U 500-999
V 1000-1499
W 1500-2499
X 2500-4999
Y 5000+

Many Thanks

that is great but I really need it without the command button and as a formula if at all possible.... so you enter the quantity and it automatically gives the result?

Pinching Andy's solution to 99 % I've instead used the "Private Sub Worksheet_Change" command to fire the macro so as soon as a value is entered in cell G7 this will update the sheet.

Alf

Ps Any credit for solving this problem should be given to Andy!

Not at all you did the job, I just added a bit of icing on the cake.

Alf

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

Thanks exactly what I was after SixthSense many thanks to all of you for your help and assistance