Column B rigidly chops of the last 4 characters and looks that up. Not good if there aren't exactly 4 characters to remove at the end.
Column C chops everything including and after the last hyphen.
Column D is a more up to date version of column c with some of the newer functions.
Take your choice.
Column B rigidly chops of the last 4 characters and looks that up. Not good if there aren't exactly 4 characters to remove at the end.
Column C chops everything including and after the last hyphen.
Column D is a more up to date version of column c with some of the newer functions.
Take your choice.