Spreadsheet: 114883d1310569245-vlookup-help-excel-help
Sheet: Lookup

Station | Line |  |  | Job Description | Station | Line | Grade
Southport | Northern
Birkdale | Northern |  |  | STATION RETAILER,PORT SUNLIGHT | Port Sunlight | Wirral | Station Retailer
Hillside | Northern |  |  | STATION RETAILER, CONWAY PARK | Conway Park | Wirral | Station Retailer
Ainsdale | Northern |  |  | STATION RETAILER, [NAME] | [NAME] | Northern | Station Retailer
Freshfield | Northern |  |  | DUTY MANAGER | Duty Manager | Facilities | Duty Manager
[NAME] | Northern |  |  | STATION ASSISTANT - JAMES ST | [NAME] | Underground | Station Assistant
Hightown | Northern |  |  | CUSTOMER EXPERIENCE MANAGER | Customer Experience | Customer Experience | Customer Experience Manager
Hall Road | Northern |  |  | AREA CUSTOMER EXPERIENCE MGR | Customer Experience | Customer Experience | Area Customer Experience Manager
Blundellsands & Crosby | Northern |  |  | CUSTOMER EXPERIENCE SUPERVISOR | Customer Experience | Customer Experience | Customer Experience Supervisor
[NAME] | Northern
Seaforth & Litherland | Northern
Bootle New Strand | Northern |  |  | I have a very large list of job descriptions in a payrol file.  I will be adding to the file each period and want an easy way to
Bootle Oriel Road | Northern |  |  | allocate a station, line and grade to each person / job description (highlighted yellow)
Bank Hall | Northern
Sandhills | Northern |  |  | I have used an if statement in H3 to return Port Sunlight but I had to manually tell it to search for Port Sunlight - is there anyway
Brunswick | Northern |  |  | to incorpoate a vlookup into this formula?
St. Michaels | Northern
Aigburth | Northern |  |  | Once I have got the station I can easily look up the [NAME] using the data table to the right.
Cressington | Northern
Liverpool South Parkway | Northern |  |  | My last problem is extracting the Grade out of the Job Descriptions, there will only ever be 6 grades all contained within the Job Description
Hunts Cross | Northern |  |  | Station Retailer
Kirkdale | Northern |  |  | Station Assistant
[NAME] | Northern |  |  | Duty Manager
Orrell Park | Northern |  |  | Customer Experience Manager
[NAME] | Northern |  |  | Area Customer Experience Manager
Old Roan | Northern |  |  | Customer Experience Supervisor
Maghull | Northern
Town Green | Northern
Aughton Park | Northern
Ormskirk | Northern
[NAME] | Northern
Fazakerly | Northern
Kirkby | Northern
Moofields | Underground
Lime Street | Underground
[NAME] | Underground
Liverpool Central | Underground
[NAME] | Underground
Birkenhead Central | Wirral
[NAME] | Wirral
Rock Ferry | Wirral
Bebington | Wirral
Port Sunlight | Wirral
Spital | Wirral
Bromborough Rake | Wirral
Bromborough | Wirral
[NAME] | Wirral
Hooton | Wirral
Capenhurst | Wirral
Bache | Wirral
Chester | Wirral
Little Sutton | Wirral
Overpool | Wirral
Ellesmere Port | Wirral
Conway Park | Wirral
Birkenhead Park | Wirral
Birkenhead North | Wirral
Wallasey Village | Wirral
[NAME] | Wirral
[NAME] | Wirral
Bidston | Wirral
[NAME] | Wirral
Moreton | Wirral
Meols | Wirral
Manor Road | Wirral
Hoylake | Wirral
West Kirkby | Wirral
Duty Manager | Facilities
Customer Experience | Customer Experience