Put this in B3

=LOOKUP(A1,Sheet2!C:C,Sheet2!B:B)

"Kelly" wrote:

I have a spreadsheet that I would like to be able to have the Job Name (In
cell B3) to be automatically entered when I type in the Job Number (In cell
B4). The list of jobs and job numbers are in sheet 2, Column A - job name and
Column B - job number. The form is on sheet 1.

Thanks for any help
Kelly