I have created an excel sheet (Sheet 1) database listing client a-z with their respective emails in columns A and B respectively.

On a different sheet (Sheet 2), I have referenced a column with data validation, such that in Column A of Sheet 2, I need to select client a,b,c,...,z. Is there a way possible on excel such that Column B of Sheet 2 automatically looks and returns the correct data for the specified client's email by referencing the database that has been created in Sheet 1?

Thank you.

[Database example (Sheet 1), with client's names and email addresses in Columns A and B respectively](https://i.stack.imgur.com/TqAW2.png)

[In Cell A2 (Sheet 2), I have selected Client 'Adam'. Is there a way Cell B2 returns 'Adam's' email automatically by referencing database (Sheet 1)?](https://i.stack.imgur.com/dz6cB.png)

Thank you