Spreadsheet: 454997d1460058191-lookup-to-return-value-from-a-different-row-example-1
Sheet: Data Sheet

 | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12
Job No | 10125701
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total
Job No | 10125702
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total
Job No | 10125703
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total
Job No | 10125704
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total
Job No | 10125705
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total
Job No | 10125706
Resource 1 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 2 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 3 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 4 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 5 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 6 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
Resource 7 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148 | 133 | 133 | 148
 |  |  |  |  |  |  |  |  |  |  |  | Total