hi, all!
can any of you tell me how do i solve this problem i am facing?
I want the correct value in the second table as indicated.
e.g., the "Value" in the first row in the second table should be 3424 (by observation) as "Location" 0.261 is within the range of 0.189 to 0.830 for Item 200000002 in the first table (second row). Now the problem is i have thousands of data. so how do i make excel do it for me, i.e., return me the right value at a location of an item as specified by the range? By using VBA/Macro. I am new to these VBA stuffs!
Any help will be appreciated.
Thanks.
Bookmarks