I'm working with Job #'s and each Job # is specified with a name.
In the first cell I want to put the job# and have it retrieve the job name
in the next cell over.

As an example I put in 0001 in A1 and in A2 the text SampleJob will appear.
I understand this will have to pull from an outside list of information most
likely, but I'm not sure how to go about doing it.

Any help?

-K