Using IF function to return value matching another value on another sheet

[Seanr19871]

Hi, I have a long list of usernames and password for work in a table on a sheet called PASSWORDS. I've added a drop down list on my dashboard with the name of each of the passwords.
In the cell below the list I want it to show the password that matches the name in the above cell, and the name in the table.
How do I do this for a list of passwords because I know how to do it for a single one (shown below)

IF(R3=Passwords!A2,Passwords!B2,"")

I want it to check the list of password names in the table and show the corresponding password next to it so in the next cell.

How do I do this?

Thanks
Sean

 

[sprigelz]

Try this.

=IFERROR(INDEX(Passwords!B:B,MATCH(R3,Passwords!A:A,0)),"")

 

[Seanr19871]

Try this.

=IFERROR(INDEX(Passwords!B:B,MATCH(R3,Passwords!A:A,0)),"")

Worked perfect, appreciate the help