Need VBA Help! Been searching for days : I have very little background in VBA but learn quick. I am working on a sheet that is exported from an online system. I have already worked out the VBA to reformat the entire sheet now I am left with my final part that has stumped me. 

1. Column B is populated with 78 possible serial numbers (6 digits long). These serial numbers relate to any one of 10 specific machine names. Think of this like Vin numbers to a car.  

2. What I would like to do in VBA is populate column A with the machine name based off the serial number listed in B. 

3. The machine name is not listed anywhere on the sheet, I was hoping to have that information stored within the formula in VBA.

Below is an example of the data I am working with. 

[Example Data][1]


  [1]: https://i.stack.imgur.com/VKxgp.jpg