View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelly Kelly is offline
external usenet poster
 
Posts: 132
Default 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