Filtering table with cells

Hello,

I have a massive table with about 5,000 items that I need to go through and I would like to filter only the items I need.

So in the workbook I attached my table with my information is on the left and the small table on the right is where I would like to be able to paste a few assets number and have the table automatically filter.

I've thought about using a Vlookup to return the value in another sheet but I need to input data in my table as I go through the items, so I'm guessing filtering it is the easiest way ?

I think "Advanced Filter" is your easiest way.

On the Data Tab> in the "Sort & Filter" section > "Advanced"
That opens the Advanced Filter Window.
Fill in the List Range and Criteria Range and hit Okay
Alternately, within that window, you can choose to copy and paste your filtered range to somewhere else in the workbook.

Is that what you are looking for?

Yes that's exactly what I'm looking for, however when I try that everything gets filtered out and the table doesn't return any of the asset lines

Edit: Just made a small mistake typing the header, Now it works fine

Hmm, see attached example (I moved rows around a little just so I could paste images at the top of the sheet.

Edit: I forgot to mention that the headers in your filter range need to be the same as your original headers. My bad.
Glad you got it working