Look in the help index for LOOKUP, MATCH,INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"da" wrote in message
...
Hi
Is there anyway following can be accomplished?
If I type the last name, the serial numer that goes with the name will be
copied from a drop down list? E. G. If I type Pharr, in the next column
75039
will pop up?

Thanks


PHARR 75039
LACKEY 75041
McFRAZIER 79064
McCULLOUGH 79069
GILMORE 79073
METCALF-EVANS 80084
SEDA 80091
JACKSON 80098
CRUTCHFIELD 80099