Forum Discussion
How to extracting an array from a data table by a variable value X ?
Hey there,
I want to extract an array from a data table by a reference value "X" which is a variable please saw the screenshot for your better understanding. How can I do that using excel formula.
2 Replies
Alternatively, you may also try this...
Assuming your ASIN's are in the range C5:C10 and values are in the range D5:I10, then...
=FILTER(D5:I10,C5:C10=O4)
