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