Posts tagged with 'isna', page 1 of 1

isna

Alternative lookup formulas

March 24, 2009 by JP

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

Worksheet matching to return row number

October 24, 2008 by JP

8 Comment(s)

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.

Filed Under: Excel

Tagged With: isna, match, vlookup