Posts tagged with 'vlookup', page 1 of 2

vlookup

Improve VLOOKUP

March 29, 2012 by JP

Comments

vlookup image

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.

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.

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))

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.

Filed Under: Excel, Tutorial

Tagged With: analysis toolpak, IF, Proper, Upper, vlookup

vlookup

Improve VLOOKUP

Table array hardcoding

Getting an approximate match from a range

Alternative lookup formulas

Excel Tutorial Series – some simple functions

Categories

Recent Posts

vlookup

Improve VLOOKUP

Table array hardcoding

Getting an approximate match from a range

Alternative lookup formulas

Excel Tutorial Series – some simple functions

Follow Me

Categories

Tags

Recent Posts