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?
|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|
|Jack Sparrow||1006||route 1||?||?||day off||?||?|