Use these articles to learn more
Find the Average of Closest 2 Numbers out of 3 [formula challenge]
at 19 January, 2011
Using Array Formulas to check if a list is sorted.
at 7 January, 2011
How to write 2 Way Lookup Formulas in Excel?
at 9 November, 2010
Using Lookup Formulas with Excel Tables [Video]
at 9 November, 2010
Extract Values from Several Columns [VLOOKUP Quick Tip]
at 8 November, 2010
6 Tips for Writing Better VLOOKUPs
at 2 November, 2010
Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]
at 1 November, 2010