The site formerly known as Code For Excel and Outlook
March 24, 2009 by · 
I was reading Dealing with VLOOKUP and GETPIVOTDATA errors by Ken Puls and noticed he wraps VLOOKUP formulas in IF statements like this:
=IF(ISNA(VLOOKUP(rngToLookup,rngToLookIn,ColToReturn,False),0, VLOOKUP(rngToLookup,rngToLookIn,ColToReturn,False))
Continue Reading: Alternative lookup formulas »
February 23, 2009 by · In this tutorial, I'll be showing you some more advanced lookup and counting functions.
But first, a logic lesson!
Continue Reading: Excel Tutorial Series – Advanced Lookup/Counting Functions »
January 28, 2008 by · This formula, entered as an array (Ctrl-Shift-Enter) in a single cell, will show you if there any duplicate entries in a given range (in this case, A1:C100). It is wrapped in an IF function to provide a friendly message; a kind of in-cell error handling, if you will. I usually do this when I know others are going to use the formula, to make it easy for them to understand the output. Otherwise it just gives you the number of unique entries which some people may not know what to do with.
Continue Reading: Counting Unique Occurrences in an Excel Spreadsheet »
Site last updated: February 9, 2012
Follow Me