Hi All,
I've run in to a sticky situation with a formula. I'm trying to generate a list of materials, which a certain customer buys. My data is currently in a separate worksheet in a table named 'Table 2'.
I'm looking for a formula that will look at the customer number entered in A21, and bring up a list of the materials that are on the same row as the customer number in 'Table 2'. This is the formula that I've tried, which works perfectly okay for the first entry, but results in #NUM! when I drag the formula down.
=IF(COUNTIF(Table2[Customer],$A$21) < ROWS($B$20:B20), “”, INDEX(Table2[Material],SMALL(IF(Table2[Customer]=$A$21,ROW(Table2[Customer])), ROW('RAW CA'!B1))))
Any help much appreciated!
Dom
Bookmarks