I TRIED TO MAKE THE TABLES CLEAR !!!! The original table: From/To indicates the range for the "value" Item____________From_______To_______Value 200000002_______0.000_______0.189_______3423 200000002_______0.189_______0.830_______3424 200000002_______0.830_______3.943_______3433 200000002_______3.943_______4.393_______865 200000002_______4.393_______5.607_______3454 200000008_______0.000_______1.278_______8889 200000008_______1.278_______5.432_______5587 200000010_______21.625_______21.812_______4564 200000010_______21.812_______22.468_______4777 200000010_______22.468_______24.624_______4556 200000012_______27.068_______41.089_______6689 200000012_______41.089_______42.007_______7688 I want correct values in the "Value" column in the following table: Item_____________Location_______Value 200000002_______0.261_______(the right value is 3424) 200000008_______0.5__________??? 200000008_______3.698________??? 200000008_______4.32_________??? 200000008_______15.396_______??? 200000008_______15.757_______??? 200000008_______16.417_______???