Extract Rows of Data Based on One Column Criteria

[ekgreen23]

Hello Excel Fam.
In need of assistance again.
In the spreadsheet, I"m looking to extract all rows of data that match the case number in the Case Number Needed column below.
So based off of the Case Number Needed column, I need to match the case number above then pull the row/s of data.
But the formula needs to be set up so that if and when any of the numbers in the Case Number Needed column show up in the table above, the rows will automatically be pulled.
I appreciate your help in advance.
Thank you!!

[Shareez Saleem]

Please Login or Register  to view this content.