Seanr19871
New Member
- Joined
- May 14, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- MacOS
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
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