You'd want to use Vlookup().

Check out this web page of Debra Dalgleish on the subject:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pkpocket" wrote in message
...

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