Does my solutin works:

Sheet1.
B C D E F G
2 Worker Job#1 Job#2 Job#3 Job#4 Job#5
3 Sean 25 hr 32 hr 65 hr 58 hr 12 hr
4 Joe 50 hr 15 hr 35 hr 45 hr 45 hr
5 Johan 30 hr 20 hr 24 hr 65 hr 14 hr
6 Steve 40 hr 45 hr 15 hr 45 hr 47 hr
7 William 15 hr 25 hr 45 hr 14 hr 41 hr

Sheet2
B C D E F G
2 Job Joe Johan Sean Steve William
3 Job#1 50 hr 30 hr 25 hr 40 hr 15 hr
4 Job#2 15 hr 20 hr 32 hr 45 hr 25 hr
5 Job#3 35 hr 24 hr 65 hr 15 hr 45 hr
6 Job#4 45 hr 65 hr 58 hr 45 hr 14 hr
7 Job#5 45 hr 14 hr 12 hr 47 hr 41 hr

Formula in Sheet2 cell C3:
=INDEX(Sheet1!$C$3:$G$7;MATCH(C$2;Sheet1!$B$3:$B$7 ;0);MATCH($B3;Sheet1!$C$2:$G$2;0))
Formula in Sheet2 cell G7:
=INDEX(Sheet1!$C$3:$G$7;MATCH(G$2;Sheet1!$B$3:$B$7 ;0);MATCH($B7;Sheet1!$C$2:$G$2;0))

--
A.B.


"Dave" rakstîja:

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!