Formula for finding all the rows with the any of the values in a column.

Hi, and thanks for your help last time. I am trying to sort through around 200,000 rows for information on orders to Tianjin city. I filtered Column "F" for all rows containing the words "Tianjin" and "distribution center". Now that I have the rows containing orders to Tianjin, I need to search the order numbers Column "A" to get all information on these orders. For example, if the package went through another city first this information won't show up with the filtered criteria.

I need to find all the rows that have any one of the values in Column "A". Essentially I need to search the entire chart for around 1000 different number combinations, the order numbers in column A. Is there a formula for that?

屏幕快照 2018-04-02 上午10.00.37.png

Attach a sample workbook not a useless picture. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is the file with all of the problems and BEFORE and AFTER worksheets.