I was recently teaching a class on Vlookups() – what I call one of the “usual suspects” and one of the participants had a question around how to speed up her vlookups – particularly when the headings were the same. If you are not sure how the Match function works – check out this tutorial
I proceeded to demonstrate with the attached file. Alas, the demonstration didn’t work as I had planned. I am sure you are familiar with *that* feeling when it comes to Excel 🙂 but I went back to the drawing board – invoked my Excel equivalent of Scarlett O’Hara in Gone with the Wind and here’s the demo – working! . You can view the completed file here