*This post was contributed by guest author Hannah Sharron VLOOKUP is one of the most well-known Excel functions – and not without reason! If I had to tell the most used function in excel, I would say VLOOKUP. Many people would even say, that you have not learned Excel if you