Monthly Archives: March 2012

Using WorksheetFunction.VLookUp To Look Up A Date In VBA

Posted on March 27, 2012 by

VLOOKUP is exposed in VBA via the WorksheetFunction class and works much the same as it does when you use it in a worksheet, but one thing you have to be careful of is when you have a date as the lookup_value. … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , | 3 Comments

Why Does VLOOKUP Return An #N/A Error?

Posted on March 26, 2012 by

VLOOKUP week enters its second day, meaning that it’s time to have a look at how to problem-shoot #N/A errors. On the online forums I frequently see frustrated users asking why their VLOOKUP formula returns an #N/A error, so I hope that some of the … Continue reading →

Posted in Microsoft Excel | Tagged , , | 128 Comments

Binary Searches With VLOOKUP

Posted on March 25, 2012 by

I went for a job interview about a year ago and the interviewer made a passing comment that he didn’t understand why anyone would ever pass TRUE into VLOOKUP’s  range_lookup parameter. There are lots of cases when you might want to … Continue reading →

Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 10 Comments

VLOOKUP Week

Posted on March 21, 2012 by

Bill Jelen is dedicating 25th – 31st March to one of Excel’s most popular worksheet functions: VLOOKUP. In addition to  doing VLOOKUP themed podcasts, e-book excerpts and drawings over at his MrExcel.com website, he’s also going to curate all the VLOOKUP Week posts from across … Continue reading →

Posted in Microsoft Excel | Tagged , , | 5 Comments

Keep It Clean

Posted on March 13, 2012 by

VBA Code Cleaner is a free and indispensable utility created by Rob Bovey which can be downloaded at his website. According to the information on Rob’s site, when you’re writing VBA code, a lot of unwanted junk accumulates behind the … Continue reading →

Posted in Microsoft Excel, Microsoft Office | Tagged , , | 8 Comments

Knight’s Tour

Posted on March 1, 2012 by

The knight’s tour is a chess puzzle where you have to move a knight around a chess board so that it visits each square once. An Excel worksheet grid lends itself to being a chessboard so, when prompted by a … Continue reading →

Posted in Microsoft Excel | Tagged , , | 1 Comment