EXCEL2007 VLOOKUP Function Formula #n/a solving method

Office software EXCEL2007 VLOOKUP function formula prompts #n/a error, that when there is no value in the function or formula, then we are very clear that this function formula is wrong, I now use =vlookup (a:a,sheet3! a:b,2,0) This error formula Ishikawa. Why is it wrong to analyze it?

If it's the wrong symbol for the input formula, we just need to modify our formula. As shown in this worksheet we are using the VLOOKUP function formula, the original formula is: =vlookup (a:a,sheet3! a:b,2,0).

So how do we modify this formula, which is to change the original formula to this: IF (ISERROR (original formula)), "", the original formula)). Our previous formula is this: =vlookup (a:a,sheet3! a:b,2,0), this is the change: =if (ISERROR VLOOKUP (a:a,sheet3! a:b,2,0)), "", VLOOKUP (a:a,sheet3! a:b,2,0)).

The formula changes and press ENTER will appear as shown, when we can see the previous error symbol appears blank, then we just need to pull the formula down, we can all remove the error symbol! It is also possible if other formulas are modified in this way.

Thank you for watching small series for everyone to edit the EXCEL2007 vlookup function Formula #n/a solution, this tutorial using many versions of Excel, please save the collection, thank you!