Multiple Filters and Sorting on Database, VLOOKUP

Excel 2016
I have imported a database onto excel consisting of about 200 columns and 12,000 rows. Each column has different values (5 and 9-number zip codes, name, range, address, number, state, %, etc.).
Sample Rows:
- 00850 (zip code)
- Noname Company
- 100 Address Street
- 10-25%, Up to 10%
- $40,000
- CA
Each row has a unique ID #, and I am currently using advanced filter for find rows located in certain zip codes. After I have filtered by zip code, I copy the ID #s onto another sheet and use VLOOKUP to show the most important columns for a more printer-friendly layout.
I am wondering if there is a way I can use multiple filters and sorting before I copy the ID #s. For example, filter by using the zip code tool, 50-75%, $5,000-$10,000 (I have tried uncecking and checking boxes under filter, but it takes a very long time). When I use the advanced filter tool for zip codes, I am not able to use other filters without it deleting my advanced filter and vis versa.
If there is another way to filter or sort multiple columns, or even putting a search bar at the top of the rows, without implementing any macros, it would make my life a lot easier. Please let me know.
Thank you.

@tamthat

Thank you for your response.

I was able to review the advanced filter link however, upon trying it on my excel sheet, it did not work properly.
As a test, I used the filter criteria for "Los Angeles; New York" in the "City" column, "<1,000; >200" in the "money" column, and listed about 50 zip codes in the "zip code" column. I was hoping my results would show all rows that have Los Angeles or New York, be between 200-1,000 in money, and be in any of the zip codes I inputted. However, my results only listed rows with New York and Los Angeles within the given zip codes (there was no filtering for money). My first result was New York (city), 10055 (zip code), 10,000 (money).

Is there another method in which to filter and search for large amounts of data? Perhaps I am using the advanced filter tool wrong.

Thank you for your help.