I have a project that is getting more complicated than I had anticipated. I
have a worksheet that has an input box used to input initials. The employee
inputs a password and an IF statement places the correct initials in the
correct cell. I currently have a nested IF statement to sort the three or
four different possibilities. The problem I have with this process is that
if the employee changes or if there is just a new one I have to rebuild the
IF statement to make it work for that employee. I need a look up formula to
do what the IF statement is doing. That way I can build a range that the
employee name would be added to and all would work.

Here is what I would build as a range:

Column D: ID ( Not sure if I need this part of the range)
Column E: Password
Column F: Name
Column G: Initials

Rows 16 through 50

I would name this range "Password"

I need a formula that will look up the password and return the initials.

I plan to build a user form to enter the information into the range as needed.

Thanks for ANY help given.

Mike Rogers