hey, bhusan: I guess, I made my question a lil complicated. actually, i want the correct value in the second table. e.g., the value in the first row in the second table should be 3424 (by observation) as location 0.261 is in the range of 0.189 to 0.830 in the first column, right? similarly, the value in the last row at location 16.417 against Item 200000008 is none as this location is beyond the range of 0 to 1.278 and 1.278 to 5.432 against Item 200000008 in the first table. i have thousands of data. so the question is how do i make excel to do it for me, ie, return me the right value at a location of an item as specified by the range. hey, bostongirl: Yes the location is not the same. these are the given locations at which i need the correct values from first table in which the values are specified by the range. clear?? hey, Slackdemic: I will try to include the screenshots! hey, TM: Yes. thats true. but thats how i got the data - thousands of entry. i guess we will have to ignore that part. GUYS!!! LEMME KNOW IF U STILL VE QUESTIONS.