Change the formula Bill gave you to this:

In B13 type: =VLOOKUP(A13,A5:B6,2,0)

Copy this formula down to B14

Now when you type an employee number into A13 or A14 you'll get the
corresponding names in B13 and B14


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=398406