Job Number Lookup and Match with Job Name
 

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

Job Number Lookup and Match with Job Name
 

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

Job Number Lookup and Match with Job Name
 

Oops wrong lookup address in last post. Once again enter in B3

=LOOKUP(B4,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

Job Number Lookup and Match with Job Name
 

Hello Mike:
I am sure it's something I've done but I tried this and it did'nt work.

Kelly


"Mike" wrote:

Oops wrong lookup address in last post. Once again enter in B3

=LOOKUP(B4,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