software

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 quot;Passwordquot;

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 RogersTry this:

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

HTH
Jean-Guy

quot;Mike Rogersquot; wrote:

gt; I have a project that is getting more complicated than I had anticipated. I
gt; have a worksheet that has an input box used to input initials. The employee
gt; inputs a password and an IF statement places the correct initials in the
gt; correct cell. I currently have a nested IF statement to sort the three or
gt; four different possibilities. The problem I have with this process is that
gt; if the employee changes or if there is just a new one I have to rebuild the
gt; IF statement to make it work for that employee. I need a look up formula to
gt; do what the IF statement is doing. That way I can build a range that the
gt; employee name would be added to and all would work.
gt;
gt; Here is what I would build as a range:
gt;
gt; Column D: ID ( Not sure if I need this part of the range)
gt; Column E: Password
gt; Column F: Name
gt; Column G: Initials
gt;
gt; Rows 16 through 50
gt;
gt; I would name this range quot;Passwordquot;
gt;
gt; I need a formula that will look up the password and return the initials.
gt;
gt; I plan to build a user form to enter the information into the range as needed.
gt;
gt; Thanks for ANY help given.
gt;
gt; Mike Rogers
gt;

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

quot;pinmasterquot; wrote:

gt; Try this:
gt;
gt; assuming the password to lookup is in A1
gt; =VLOOKUP(A1,$E$16:$G$50,3,0)
gt;
gt; HTH
gt; Jean-Guy
gt;
gt; quot;Mike Rogersquot; wrote:
gt;
gt; gt; I have a project that is getting more complicated than I had anticipated. I
gt; gt; have a worksheet that has an input box used to input initials. The employee
gt; gt; inputs a password and an IF statement places the correct initials in the
gt; gt; correct cell. I currently have a nested IF statement to sort the three or
gt; gt; four different possibilities. The problem I have with this process is that
gt; gt; if the employee changes or if there is just a new one I have to rebuild the
gt; gt; IF statement to make it work for that employee. I need a look up formula to
gt; gt; do what the IF statement is doing. That way I can build a range that the
gt; gt; employee name would be added to and all would work.
gt; gt;
gt; gt; Here is what I would build as a range:
gt; gt;
gt; gt; Column D: ID ( Not sure if I need this part of the range)
gt; gt; Column E: Password
gt; gt; Column F: Name
gt; gt; Column G: Initials
gt; gt;
gt; gt; Rows 16 through 50
gt; gt;
gt; gt; I would name this range quot;Passwordquot;
gt; gt;
gt; gt; I need a formula that will look up the password and return the initials.
gt; gt;
gt; gt; I plan to build a user form to enter the information into the range as needed.
gt; gt;
gt; gt; Thanks for ANY help given.
gt; gt;
gt; gt; Mike Rogers
gt; gt;

pinmaster

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

quot;Mike Rogersquot; wrote:

gt; pinmaster
gt;
gt; Thanks for the reply. I get the ole #N/A error and the information is in
gt; the range, I double checked the range and the password, I did use A1. What
gt; could I have done wrong?
gt;
gt; Mike Rogers
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; assuming the password to lookup is in A1
gt; gt; =VLOOKUP(A1,$E$16:$G$50,3,0)
gt; gt;
gt; gt; HTH
gt; gt; Jean-Guy
gt; gt;
gt; gt; quot;Mike Rogersquot; wrote:
gt; gt;
gt; gt; gt; I have a project that is getting more complicated than I had anticipated. I
gt; gt; gt; have a worksheet that has an input box used to input initials. The employee
gt; gt; gt; inputs a password and an IF statement places the correct initials in the
gt; gt; gt; correct cell. I currently have a nested IF statement to sort the three or
gt; gt; gt; four different possibilities. The problem I have with this process is that
gt; gt; gt; if the employee changes or if there is just a new one I have to rebuild the
gt; gt; gt; IF statement to make it work for that employee. I need a look up formula to
gt; gt; gt; do what the IF statement is doing. That way I can build a range that the
gt; gt; gt; employee name would be added to and all would work.
gt; gt; gt;
gt; gt; gt; Here is what I would build as a range:
gt; gt; gt;
gt; gt; gt; Column D: ID ( Not sure if I need this part of the range)
gt; gt; gt; Column E: Password
gt; gt; gt; Column F: Name
gt; gt; gt; Column G: Initials
gt; gt; gt;
gt; gt; gt; Rows 16 through 50
gt; gt; gt;
gt; gt; gt; I would name this range quot;Passwordquot;
gt; gt; gt;
gt; gt; gt; I need a formula that will look up the password and return the initials.
gt; gt; gt;
gt; gt; gt; I plan to build a user form to enter the information into the range as needed.
gt; gt; gt;
gt; gt; gt; Thanks for ANY help given.
gt; gt; gt;
gt; gt; gt; Mike Rogers
gt; gt; gt;

I'm guessing that your range is not on the same worksheet as the formula so
you may need to make some ajustments.
i.e =VLOOKUP(A1,Sheet2!$E$16:$G$50,3,0)
and make sure A1 is the correct cell, I only use A1 as an example so yours
may be different, ajust accordingly.

If that is not the case then it may be text related, maybe an extra space or
a format issue, numbers formatted as text. Check those out and report back.

HTH
JG
quot;Mike Rogersquot; wrote:

gt; pinmaster
gt;
gt; Thanks for the reply. I get the ole #N/A error and the information is in
gt; the range, I double checked the range and the password, I did use A1. What
gt; could I have done wrong?
gt;
gt; Mike Rogers
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; assuming the password to lookup is in A1
gt; gt; =VLOOKUP(A1,$E$16:$G$50,3,0)
gt; gt;
gt; gt; HTH
gt; gt; Jean-Guy
gt; gt;
gt; gt; quot;Mike Rogersquot; wrote:
gt; gt;
gt; gt; gt; I have a project that is getting more complicated than I had anticipated. I
gt; gt; gt; have a worksheet that has an input box used to input initials. The employee
gt; gt; gt; inputs a password and an IF statement places the correct initials in the
gt; gt; gt; correct cell. I currently have a nested IF statement to sort the three or
gt; gt; gt; four different possibilities. The problem I have with this process is that
gt; gt; gt; if the employee changes or if there is just a new one I have to rebuild the
gt; gt; gt; IF statement to make it work for that employee. I need a look up formula to
gt; gt; gt; do what the IF statement is doing. That way I can build a range that the
gt; gt; gt; employee name would be added to and all would work.
gt; gt; gt;
gt; gt; gt; Here is what I would build as a range:
gt; gt; gt;
gt; gt; gt; Column D: ID ( Not sure if I need this part of the range)
gt; gt; gt; Column E: Password
gt; gt; gt; Column F: Name
gt; gt; gt; Column G: Initials
gt; gt; gt;
gt; gt; gt; Rows 16 through 50
gt; gt; gt;
gt; gt; gt; I would name this range quot;Passwordquot;
gt; gt; gt;
gt; gt; gt; I need a formula that will look up the password and return the initials.
gt; gt; gt;
gt; gt; gt; I plan to build a user form to enter the information into the range as needed.
gt; gt; gt;
gt; gt; gt; Thanks for ANY help given.
gt; gt; gt;
gt; gt; gt; Mike Rogers
gt; gt; gt;

Glad to hear it. Here's a nice tutorial on user forms.

www.contextures.com/xlUserForm01.html

Good Luck

Regards
Jean-Guyquot;Mike Rogersquot; wrote:

gt; I have a project that is getting more complicated than I had anticipated. I
gt; have a worksheet that has an input box used to input initials. The employee
gt; inputs a password and an IF statement places the correct initials in the
gt; correct cell. I currently have a nested IF statement to sort the three or
gt; four different possibilities. The problem I have with this process is that
gt; if the employee changes or if there is just a new one I have to rebuild the
gt; IF statement to make it work for that employee. I need a look up formula to
gt; do what the IF statement is doing. That way I can build a range that the
gt; employee name would be added to and all would work.
gt;
gt; Here is what I would build as a range:
gt;
gt; Column D: ID ( Not sure if I need this part of the range)
gt; Column E: Password
gt; Column F: Name
gt; Column G: Initials
gt;
gt; Rows 16 through 50
gt;
gt; I would name this range quot;Passwordquot;
gt;
gt; I need a formula that will look up the password and return the initials.
gt;
gt; I plan to build a user form to enter the information into the range as needed.
gt;
gt; Thanks for ANY help given.
gt;
gt; Mike Rogers
gt;

Thanks pinmaster, that is the one that I was going to use.
Thank you for working within this forum!!!

quot;pinmasterquot; wrote:

gt; Glad to hear it. Here's a nice tutorial on user forms.
gt;
gt; www.contextures.com/xlUserForm01.html
gt;
gt; Good Luck
gt;
gt; Regards
gt; Jean-Guy
gt;
gt;
gt; quot;Mike Rogersquot; wrote:
gt;
gt; gt; I have a project that is getting more complicated than I had anticipated. I
gt; gt; have a worksheet that has an input box used to input initials. The employee
gt; gt; inputs a password and an IF statement places the correct initials in the
gt; gt; correct cell. I currently have a nested IF statement to sort the three or
gt; gt; four different possibilities. The problem I have with this process is that
gt; gt; if the employee changes or if there is just a new one I have to rebuild the
gt; gt; IF statement to make it work for that employee. I need a look up formula to
gt; gt; do what the IF statement is doing. That way I can build a range that the
gt; gt; employee name would be added to and all would work.
gt; gt;
gt; gt; Here is what I would build as a range:
gt; gt;
gt; gt; Column D: ID ( Not sure if I need this part of the range)
gt; gt; Column E: Password
gt; gt; Column F: Name
gt; gt; Column G: Initials
gt; gt;
gt; gt; Rows 16 through 50
gt; gt;
gt; gt; I would name this range quot;Passwordquot;
gt; gt;
gt; gt; I need a formula that will look up the password and return the initials.
gt; gt;
gt; gt; I plan to build a user form to enter the information into the range as needed.
gt; gt;
gt; gt; Thanks for ANY help given.
gt; gt;
gt; gt; Mike Rogers
gt; gt;