Archive for January 22nd, 2010
Nifty Tip #2: Combining the VLOOKUP and MATCH formulas
The VLOOKUP formula returns data from any column you choose in the data table. All you have to do is change the number of the column in the third argument, right? Well, it sounds easy, but there is a little catch. How can you determine the number of a column in a data table that [...]