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 »
October 24, 2008 by · I have a worksheet with a list of company names in column A (we'll call it 'Worksheet1'), and another worksheet with a list of similar company names in column A ('Worksheet2'). Both lists have a header row, so the data starts in cell A2 of each worksheet.
Continue Reading: Worksheet matching to return row number »
Site last updated: February 8, 2012
Follow Me