Looking up
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
|