Look Up a number

[da]

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

 

[Don Guillett]

Look in the help index for LOOKUP, MATCH,INDEX

 

[Jacob Skaria]

Try the below with Pharr in cell A1

=vlookup(A1,E:G,2,0)

If this post helps click Yes