If you are going to copy that formula down you'll want to use absolute
references for the lookup range:

=VLOOKUP(A13,$A$5:$B$6,2,0)

Regards
Rowan

"Cutter" wrote:


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