Filter two data sets my matching indexes

Please attach a sample workbook so that we don't have to retype the data and can play with your data.
For how to upload a spreadsheet, check out the link in my signature below.

Hey QP,

This looks like and Advanced Filter problem to me. First put headers on your data in Row 1. Make the data of the Advanced Filter Columns C and D. Make the Criteria range column A and output the result to F. You could filter in place but then it hides rows. See my example:

Advanced Filter Problem Criteria on Left.xlsx

Clear the results area first. F:G -> Clear Contents. Then instead of selecting the entire column, just select the range with data. This is most important in the criteria range of column A. Also, did you put headers on your columns? The titles of the columns for the data and criteria need to be spelled exactly the same. If you have data that grows or shrinks then using a few Named Ranges may make your work easier. See the attached where I do this for a problem with a variable dropdown list. This has vba code that does the advanced filter like you want with named ranges.

Event to AdvFilter to DNR Validation Dropdown.xlsm

You can also try this macro-

Sub match_index()
l = Range("A" & Rows.Count).End(xlUp).Row
Range("E1").Resize(l).Value = Range("D1").Resize(l).Value
For n = 2 To l
target = Application.Match(Range("A" & n).Value, Range("C:C"), 0)
Range("D" & n).Value = Range("E" & target).Value
Next n
Range("C1").Resize(l).Value = Range("A1").Resize(l).Value
Range("E1").Resize(l).ClearContents

End Sub

It uses Column E as a rough column for the macro. Make sure column E is of no purpose. If it is then we can change it to any other column.
Check attached for an example.advanced filter.xlsm