software

Here is the problem that I am having. 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 quot;1quot; on cell
D1, quot;Smithquot; will populate E1, and quot;Johnquot; will populate F1. And if I
were to input quot;2quot; in cell D1, quot;Doequot; will populate E1, and quot;Janequot; will
populate F1. Thank you very much.--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=502213It sounds like a perfect use of =vlookup().

You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html (for =vlookup())

exsam21 wrote:
gt;
gt; Here is the problem that I am having. I have three columns with
gt; 'employee #', 'Last Name', and 'First Name'.
gt;
gt; A B C
gt; Emp# Last First
gt; 1 Smith John
gt; 2 Doe Jane
gt; . .
gt; . .
gt; . .
gt;
gt; I want to set up a formula so that when I input the number quot;1quot; on cell
gt; D1, quot;Smithquot; will populate E1, and quot;Johnquot; will populate F1. And if I
gt; were to input quot;2quot; in cell D1, quot;Doequot; will populate E1, and quot;Janequot; will
gt; populate F1. Thank you very much.
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=502213

--

Dave Peterson