November 2010
1 post
1 tag
Goodbye Vlookup: Index/Match can play nice with...
I’ve been using a lot more of Index & Match functions together instead of Vlookup because it’s a faster calculation for Excel, faster for me to put in and copy across (especially multiple columns of lookups), and can go pull back values both right & left of the lookup column (as well as a matrix lookup).
I ran into a sang recently, though. By default, Index/Match...