Look Up a number
 

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

Look Up a number
 

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

Look Up a number
 

Try the below with Pharr in cell A1

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

If this post helps click Yes
---------------
Jacob Skaria


"da" wrote:

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