I have 2 columns. The first one will be a BSB number and the second will be the name of the bank. How can I create a formula or Macro where the first 2 or 3 digits in column 1 will determine the name of the bank in column 2. For example, If I enter 063215 in column 1, then column 2 would show 'Commonwealth' or if I enter 114879 it would return a result of 'St George', just from the first 2 or 3 digits. I'm pretty new to VBA and macro's in Excel, so please be kind. Any help would be much appreciated.