admin管理员组

文章数量:1336633

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)

本文标签: