Forum Discussion
Formula to extract running data.
=INDEX($B$1:$B$25,SMALL(IF(LEFT($A$1:$A$25,6)=$F$1,ROW($1:$25)),ROW(E1)))
=INDEX($C$1:$C$25,SMALL(IF(LEFT($A$1:$A$25,6)=$F$1,ROW($1:$25)),ROW(E1)))
If your search criteria (e.g. NHWHSE) has 6 digits you can use above formulas as shown in attached example file. Enter formula as arrayformula if you don't work with Office365 or 2021. The formulas can easily be adapted to other ranges and to other number of digits.
Thank you for the input. However, as you can see in the example, even when changing the references cell, I get the same responses. So it is not pulling out the data required. I may need to bypass the formula all together and create a separate work book that has the data filtered 100 different times to extract the specific parts for each order.
In the attached file you can select a search value from the dropdown list in cell F1 to display the results dynamically. Is this what you want to do? I adapted the formulas for the search values in cells I1, L1 and O1 and it works as intended in the attached file.