i have several sheets. One is called Dropdown.Template in cell I4 i have a dropdown list with 5 entries one in is "ITEM" in cell h4 is the count of that Item (107) in a table (not an excel table: I just call it that) on sheet called Lists in range F13:F362. In cell I7 on Dropdown.Template I have a cell that status says Open (261) in cell H7 the count of 'open' from lists!e13:e362 in cell J7 is a sumproduct (261) of those two. The formula should show the results of the index/match from items!j11:j362 . I want this list to expand to show all results I've tried several ways, the last one was =IF(ROWS(H$11:H11)<=$J$7,INDEX(Lists!E$13:J$362,SMALL(IF(Lists!$F$13:$F$362=$I$4,IF(Lists!$E$13:$E$362=$I$7,ROW(Lists!$F$13:$F$362)-ROW(Lists!$F$13)+1)),ROWS(H$11:H11))),"")
I have even tried vlookup!
HELP
I have even tried vlookup!
HELP
