validating username and password thats stored on a sheet.

Hello,

I have a simple issue yet hard for me to figure out. If i have ten usernames in column "A" and i want to match the corresponding password in the same row but in column "D", how do i do that?

So my user name is for example TEST and its in column "A2", my password is for example TESTING, but its in "D2". How can I check that the username that was entered in the textbox actually exist in column "A" and if it does, how do i check in column "D" that it matches?

Please help, i have been trying and experimenting with this for a while with no result, thank you.

Ok, thanks for your interest in helping. I have a list of usernames in column "A", when the user are registering for the application, they are prompted to enter their username. The app will then cycle through all the usernames that i have already created and if the username the person is entering exist in the list i already created, it allows them to create a password for this user, the password is then stored in column "D". All that i have said above, i have already created codes to do.

where i am having the problem is how do i validate the information? If the usermane in "A3" is mcintyre, then when i am registering its going to store the password i create in "D3".

When the user is logging in, how do i let the username he entered in the username field match what is in "A3" and how do i let the password that he entered match what is in "D3"?

Thank you again in your interest in helping, I have uploaded a file similar to what i want to do. I had to remove most of it to get it to the size required for uploading here, but there should be enough to help you help me, thank you.

sorry, the password is "jesus", or if you wish i can upload an unprotected version, thanks.

TMS, the issue is, if i register a user to the application, the information stores, the username, the password, the retype password, the validation answer, they all stay. However, if i try to register again, i am trying to let it say user already registered. The application will already have a list of usernames in column "A" that will be able to use the application. If your username is not in the list in column "A", then a message display saying "user is not authorized for emailing".

Let me know if i have described the issue clearly for you to help, if not i can try explaining again, no prob.

Any help here?

Help!!

Help!!

Hello, is it that this task is hard to do, or it cannot be done? I am trying really hard to get it done, but cant figure it out and I seem to not be able to get help via this forum either which is a first. Normally when i post something here, people would try and assist, but for this one i havent got much responses. If it can be done, someone please assist.

help, help, help!!!!!