Dear experts,

I've data in 3 columns. Column A is staff names and Column C is client
names. Please see an example below:

Column A Column C
Peter Spring Co
Peter Tom's Brothers
Joe Brooklyn Investments
Joe World Atlas
Joe Yiu's Restaurant

In another worksheet cells A1 & B1, I want to use for VLOOKUP. In cell A1, I
input "Peter". In cell B1, I input: =VLOOKUP($A$1,'SALES'!A2:C6,3), it
returns "Tom's Brothers" only. What I want is when I input "Peter" in cell
A1, in cell B1, Peter's two clients' names can appear in a drop-down menu for
me to choose. Is it possible? If yes, please teach me how to do it.

Thanks in advance.