Improve VLOOKUP March 29, 2012 by JP Comments It's VLOOKUP Week, apparently. So let's get to it. Continue Reading » Filed Under: Excel Tagged With: Excel, formula, vlookup
Table array hardcoding November 16, 2010 by JP 2 Comment(s) Here's something I thought might be useful, but I'm not yet sure how. Continue Reading » Filed Under: Excel Tagged With: array, table, vlookup
Getting an approximate match from a range January 22, 2010 by JP 2 Comment(s) In Return value if in range in excel, Oscar shows us a formula for returning values in a column based on a number range. Let's review his formula and also provide a few more that can do the same thing simpler. Continue Reading » Filed Under: Excel Tagged With: INDEX, match, range, SUMPRODUCT, vlookup
Alternative lookup formulas March 24, 2009 by JP Comments 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 » Filed Under: Excel Tagged With: COUNTIF, isna, vlookup
Excel Tutorial Series – some simple functions January 13, 2009 by JP Comments This is part two of the Excel Tutorial Series. Read all tutorial posts by browsing the Tutorial category. I'll continue the tutorial series with some simple functions that can make your Excel life much easier. Continue Reading » Filed Under: Excel, Tutorial Tagged With: analysis toolpak, IF, Proper, Upper, vlookup
Follow Me