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
Last edited by rayhen; 07-26-2021 at 11:04 AM.
Sort the "Price File" by product then Date (Ascending): would you really have prices not sorted ???
=INDEX($J$2:$J$10,MATCH($B2&$A2,$I$2:$I$10&$H$2:$H$10,1))
Enter with Ctrl+Shift+Enter
@JohnTopley Excellent solution. Thank you very much.
Sorting is the most ideal state, and it is a bit more troublesome if you don't sort the formula
Cell C2 formula , Drag down
HTML Code:
@wk9128 , thank you very much for the solution.
You're Welcome. Thank You for the feedback @rayhen
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks