Look up data from multiple worksheets

[JimDandy]

I have three worksheets I'm working with. The first worksheet is source data which includes machine name and an adapter name. Each machine name in Column A can be listed multiple times, once for each type of adapter it may have installed.

In a second worksheet I have specific adapter names I’m searching for. It contains a subset of all the available adapter types that might exist on the first worksheet.

On the third worksheet, I have just one instance of each machine name in Column A and I’d like to put in Column B of that worksheet which of the adapters it has, as listed on the second worksheet.

I have included a sample worksheet that describes what I’m hoping to achieve.