North for Short
New Member
- Joined
- Nov 17, 2010
- Messages
- 46
I have a Spreadsheet which I have linked to other sheets effectively, (thanks to this board). I now want to go one step further and be able to write in a name in a column and within the same column, return a number (in this case a duty no.) I have tried Vlookup, if and match and so far, I have drawn a blank on obtaining the correct information. Is there anyway that this can be done? I have pasted a small extract with ficticious names. What I want is to know what route Jack Sparrow is doing on tuesday. I will leave it with you guys. If this has been done before, can someone point me in the right direction?
<colgroup><col><col><col><col span="6"></colgroup><tbody>
</tbody>
duty | Duty Holder | Payroll | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |
route 1 | Casey Jones | 1001 | Jack Sparrow | Casey Jones | Casey Jones | Casey Jones | Casey Jones | Casey Jones |
route 2 | Robin Hood | 1002 | Robin Hood | Jack Sparrow | Robin Hood | Robin Hood | Robin Hood | Robin Hood |
route 3 | Benny Hill | 1003 | Benny Hill | Benny Hill | Jack Sparrow | Benny Hill | Benny Hill | Benny Hill |
route 4 | Mary Shelley | 1004 | Mary Shelley | Mary Shelley | Mary Shelley | Mary Shelley | Jack Sparrow | Mary Shelley |
route 5 | Henry Morgan | 1005 | Henry Morgan | Henry Morgan | Henry Morgan | Henry Morgan | Henry Morgan | Jack Sparrow |
Reserve | Payroll | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | |
Jack Sparrow | 1006 | route 1 | ? | ? | day off | ? | ? |
<colgroup><col><col><col><col span="6"></colgroup><tbody>
</tbody>