Find and Replace problem

[brad547190]

I am trying to edit a product file. The file contains a column that has
product weights. I need to replace these weights with a shipping price for
my products. The weights vary from 1 lb - 100 lbs. I have tried to use
replace, but as I do this, I start to replace some of the cells that have
already been edited for price. Does some one have a formula or advice that I
may use for this?

 

[Bernard Liengme]

Give some info. What are the rnages? 0 to 5 lbs = $4.00, 6 to 12 = $6.00,
for example. There are few ranges we can use IF otherwise a llokup
(VLOOKUP...) would be useful
best wishes