Forum Discussion
Filter table based on a list
craygoza92 If you have office 365 the new dynamic array formulas make this really easy. 1 single formula (entered in cell Q3) is able to return the array of details from the original csv file if certain conditions are met. In this case, I paste one or several delivery numbers in column O and the rows containing those delivery numbers are returned (Columns Q:AB).
Unfortunately, the csv file you attached only had the raw data, not the Result Sheet, but here's an example which is quite flexible to adapt to several requirements. You do need office 365 for these formulas to work - feel free to test in the workbook I attached if you do.
=FILTER(A2:L18,ISNUMBER(MATCH(E2:E18,O6:O8,0)),"")
craygoza92 If you have office 365 the new dynamic array formulas make this really easy. 1 single formula (entered in cell Q3) is able to return the array of details from the original csv file if certain conditions are met. In this case, I paste one or several delivery numbers in column O and the rows containing those delivery numbers are returned (Columns Q:AB).
Unfortunately, the csv file you attached only had the raw data, not the Result Sheet, but here's an example which is quite flexible to adapt to several requirements. You do need office 365 for these formulas to work - feel free to test in the workbook I attached if you do.
=FILTER(A2:L18,ISNUMBER(MATCH(E2:E18,O6:O8,0)),"")
