Excel, Accelerated: Eliminate NA Error in VLOOKUP Task: Substitute 0 for the #N/A error in a VLOOKUP formula Context: Random database Acceleration techniques: Function: VLOOKUP Technique: Absolute referencing Function: IFERROR Time: 1:00 Buy $4.99