pinmaster

I figured it out!!! Some how when I copied and paste I picked up a "!"
after the first "(" just befroe "A1".
Works perfect! Thanks for the help!!!
On to the user form!!!

"Mike Rogers" wrote:

pinmaster

Thanks for the reply. I get the ole #N/A error and the information is in
the range, I double checked the range and the password, I did use A1. What
could I have done wrong?

Mike Rogers

"pinmaster" wrote:

Try this:

assuming the password to lookup is in A1
=VLOOKUP(A1,$E$16:$G$50,3,0)

HTH
Jean-Guy

"Mike Rogers" wrote:

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