Hey guys, I searched a lot on this topic on a bunch of forums but couldn't find what I was looking for.

So I have a contact directory with the following fields:

Name BankName Phone Email

On a separate worksheet, is it possible to have a feature where if the user selects the BankName, only the corresponding people from the bank appear in the Name field? And when the name is selected, the email and phone are automatically populated.

The second part can just be done via a vlookup I believe.

Thanks a lot for your help.