Is this what you are looking for ???

=IF(AND(E2=0,E2<=50),"$0 - $50.00",IF(AND(E2=50.01,E2<=100),"$50.01 -
$100",IF(AND(E2=100.01,E2<=500),"$100.01 -
$500",IF(AND(E2=500.01,E2<=1000),"$500.01 -
$1,000.00",IF(E2=1000.01,"1,000+","Other")))))

"BARRIOSWJ" wrote:

Can you create the formula for me using the Vlookup? Please? Thanks.
--
Thanks for your help!

Walter


" wrote:

the Vlookup reply should work.