Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
Here is the problem that I am having. I have 50 employees and I have three columns with 'employee #', 'Last Name', and 'First Name'. A B C Emp# Last First 1 Smith John 2 Doe Jane . . . . . . . . . I want to set up a formula so that when I input the number "1" on cell D1, "Smith" will populate E1, and "John" will populate F1. And if I were to input "2" in cell D1, "Doe" will populate E1, and "Jane" will populate F1. Thank you very much. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
exsam21 Wrote: Here is the problem that I am having. I have 50 employees and I have three columns with 'employee #', 'Last Name', and 'First Name'. A B C Emp# Last First 1 Smith John 2 Doe Jane . . . . . . . . . I want to set up a formula so that when I input the number "1" on cell D1, "Smith" will populate E1, and "John" will populate F1. And if I were to input "2" in cell D1, "Doe" will populate E1, and "Jane" will populate F1. Thank you very much. ASSUME that your table range is A1:C50, enter this formula in: Cell E1: =vlookup(D1,A1:C50,2,0) Cell F1: =vlookup(D1,A1:C50,3,0) Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
#N/A is what I am getting. I am not sure why. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
In E1 enter =VLOOKUP(D1,A2:C10,2,0)
In F1 enter =VLOOKUP(D1,A2:C10,3,0) HTH Regards, Howard "exsam21" wrote in message ... Here is the problem that I am having. I have 50 employees and I have three columns with 'employee #', 'Last Name', and 'First Name'. A B C Emp# Last First 1 Smith John 2 Doe Jane . . . . . . . . . I want to set up a formula so that when I input the number "1" on cell D1, "Smith" will populate E1, and "John" will populate F1. And if I were to input "2" in cell D1, "Doe" will populate E1, and "Jane" will populate F1. Thank you very much. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
Nevermind the last message. I got it now. Thank you so very much. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Names
#N/A is what I am getting. I am not sure why.
Make sure the lookup number, 1, 2, 3 etc in column A is really a number. Check for leading or trailing spaces. If the numbers are to the left in the cell in column A, they are text and the number in D1 is a real number which will return #N/A. HTH Regards, Howard "exsam21" wrote in message ... Here is the problem that I am having. I have 50 employees and I have three columns with 'employee #', 'Last Name', and 'First Name'. A B C Emp# Last First 1 Smith John 2 Doe Jane . . . . . . . . . I want to set up a formula so that when I input the number "1" on cell D1, "Smith" will populate E1, and "John" will populate F1. And if I were to input "2" in cell D1, "Doe" will populate E1, and "Jane" will populate F1. Thank you very much. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502216 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
Convert Local Names to Global Names | Excel Worksheet Functions | |||
Replace range names with cell references? | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |