Hi, I could probably solve this in VBA, but there's got to be a better way to do this in Excel.
I'd like collect every instance of an entry in list A, that appears in list B (with its search criteria), and put it in a results table, as shown below.
For example:
I'd like collect every instance of an entry in list A, that appears in list B (with its search criteria), and put it in a results table, as shown below.
For example:
![Excel_Challenge.png](/board/proxy.php?image=http%3A%2F%2Fs11.postimg.org%2F6a2gyrqg3%2FExcel_Challenge.png&hash=927709258b640d4fe8a9551ad885e5d9)