Requirement description: Set the formula in column C, and find data that meets the following conditions in columns H to J according to columns B and A:
According to the item number in column B, go to columns H to J to get the price whose date is less than or equal to the corresponding date in column A
For example: the second row A material number 2021/7/20 corresponds to the price of column H to J is 32
Can someone please help me ? It would be much appreciated. Thanks in advance
Bookmarks