I have a file having part code with its buy date.In other sheet,the details date range value exist of that part.Now,I want to apply an excel formula ,to look the date of a part and insert the exact value from the date range of that part.Means,date should be fall between the range and insert the exact value.Is there an excel formula?
For more clarification,please see the attach file.
Regards
Pradeep Kumar Gupta
Bookmarks