My workbook prompts the user for his/her password via a macro using InputBox.

password = InputBox("Please enter your password")

Once entered, I need a macro to find that password in the hidden "Roster" sheet of 200 users and return the user's name that is located in the next column over.

Please help.