Currently I have this formula
=FILTER('CPFR Paste'!H:AK,('CPFR Paste'!G:G="Receipt Plan")*(ISNUMBER(XMATCH('CPFR Paste'!B:B,A2#))))
I am trying to reformat data from the CPFR Paste sheet by matching SKU from a SKU list in array A2# as well as a Measure in 'CPFR Paste'!G:G.
What I would like to have solved is matching the order of array A2# in the final output and matching the number of lines in the final result. If the SKU in A2# is not in the filtered array, then I would like to return a blank row in the result.
TABS in file:
SKU List (notice the order of the skus matters here)
CPFR Paste (Where the data comes from)
Constrained Sales Forecast (Where the constrained sales forecast data should be returned to)
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1742340165a4425465.html
评论列表（0条）