In spreadsheet 1, have a spreadsheet which has peoples names, job numbers
and the number of hours they worked on various jobs.

Spreadsheet 1
Col A Col B Col C
Row1. Job# 1 Job #2
Row2 Mr A.. 54hr 21hr etc
Etc

Spreadsheet 2
Row 1ColA (col b)Mr A. Mr B. Mr. C
Job#1 **
Job#2
etc

** (I want a function that will look for the job# and the person's name in
spreadhseet 1 and if the name matches and the hrs for that Job3 in
spreadsheet 1, then put the persons name (e.g B1 Mr A.) in this cell in
spreadsheet 2.

What is the best way to do this? Thanks!