Monthly Archives: March 2012

Using WorksheetFunction.VLookUp To Look Up A Date In VBA

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?

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 , , | 127 Comments

Binary Searches With VLOOKUP

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

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

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

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