vlookup vs Index match function

Hi FDibbins,

Thank you so much your assistance, the tips and information.

I currently work for a University and each term I have the task of coding business and occupation fields against it's relevant ANZSCO code. It is a task that requires a lot of time, patience and accuracy.

With your generous help I was able to upload the file for your review. Please note that
'sheet 1' is the master spreadsheet (table array) and 'sheet 2' is the working spreadsheet.

Any further tips would be greatly appreciated.