I am trying to do a index match on employee number and academic grade and return the academic grade. However I am looking for the academic grade to be searched against its qualification (i.e. Bachelor or Masters) which ignores if it is a 'Bachelor of Science' or 'Bachelor (Hons)', etc.
I can't quite work the isnumber function into the index match so any help appreciated.
James
Bookmarks