| 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 |
| 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 | |||
Threaded Mode
