| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returns blank if no match | Excel Worksheet Functions | |||
| Match Index Lookup | Excel Discussion (Misc queries) | |||
| Lookup nearest value (Index & Match) | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Linear Mode
