Max,

Firstly, many thanks for taking the time to answer the question.

Unfortunately, your solution does not answer my original question and my
Excel expertise is novice.

I may seem that I asked multiple questions, but I am sure that the above can
be achieved by the use of nested If Then Else statements.

I will endeavourer to plod on using manual procedures.

Once again thank you.

"Max" wrote:

One thought to help you along ...

Think you could try something like this to grab the labels (vlookup)
Eg in B25:
=IF(A25="","",VLOOKUP(A25,{1,"Normal Price";41,"41-100 Price";101,"100+
Price"},2))

p/s: To make your post attractive to answer, stick to 1 question per post
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---