MS EXCEL experts out there, I need help!!!!! For example, the following is 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 ??? How do I get the right values in the "Value" column. I used VLOOKUP function of Excel but the problem is that VLOOKUP only looks at the first match in the "Item" field. How do I make it to look at the next row when the first match does not meet the criteria? I tried VBA/Macro but my knowledge is limited in these fields. Helps will be appreciated.