Based on your sequence, it looked like a typo so allowed for that without
confusion.

Thanks for the feedback.

On Sat, 30 Jun 2007 13:42:45 -0500, "Saxman"
wrote:

Gord Dibben wrote:

Assuming 15-29 is a typo and you meant 15-19

I did, sorry for the confusion.

Enter this formula in B1

=LOOKUP(A1,{0,1,10,15,20,30,40,50,60,100},{0,1,2,3 ,5,9,12,20,25,"over 100"})

This works a treat. Thank you very much.