Return list of values ONLY when 2 other discreet values match between worksheets

[Mirlynn]

I have 2 worksheets in a Workbook.

On Sheet 1 there are 2 columns A&B - ServerName and MoveGroup respectively. ServerNames are unique but the MoveGroup field has duplicate values. Worksheet 2 has a dropdown in A1 that allows me to select a single MoveGroup value.

What I want to do is select a MoveGroup value in Worksheet2.A1 and search Worksheet1.B:B for matches and return the corresponding value where Worksheet2.A = Worksheet1.B.

In other words, I want to be able to pull a list of servers that share the same MoveGroup value. As I mentioned, there are duplicate values in Worksheet1.B so traditional Vlookup and Index/Match functions are problematic.

Secondly, I only want a list of matching servers and avoid a long list of N/A's for non matching rows - ala Index/Match function.

I assume this type of thing will need to be done in VBA using some sort of "find" loop but I am only guessing here. Also, if this the correct theory, sadly, I have no experience with writing VBA so any and all assistance would be appreciated.

Thanks in advance!

Mirlynn