using Name ranges to group customers into different pricing brackets

[stephen1000]

Hi Guys,

Not been on for a while; forgive me if I have not worded things right

I have a worksheet that needs customers split into different price bands

here we go
I have 13 customers all from the same group (a)
1 customer in group (b)
1 Customer in group (c)
& 80 independant customers (d) worksheet only has 9 (1,2,3,4,5,6,7,8,9)

Column a is a list
D17 is the drop down list
D21 is the starting price

C2:D5 is the pricing multiple to be applied

What I am trying to achieve is when an independant company is chosen it defaults to d for pricing. G17

I have the groups a,b,c working but not d

would appreciate help on this; you guys rock

Stephen