Additionally, it should also be noted that this whole process of masking errors also works exactly same with the index match formula as well.
Step 1: Open the spreadsheet containing the #N/A value that you want to replace.
Download and free trial Now!
Step 5 : Enter your error condition The error condition is what we want to show up in place of the #N/A error, or the value_if_true within the IF Statement. .Doing so makes the output look more polished and visually appealing. .It also draws less attention to the error values and lets you focus on the values that you have actually found.Iferror(XX, YY:ZZ, AA, false NO address).For example, if your formula before was: vlookup(A2, Data Source!To replace the #N/A error with blank cell if your searched value is not found, you can directx 11 windows vista 32 bit chip use this formula:, enter it into a blank cell, and press.That would show the phrase NO address instead of a 0 when Excel couldnt find the data it wanted.Increase your productivity in 5 minutes.When writing a series of, vlookup formulas, one of the annoying things is having to see the #N/A error after Excel has determined a lookup value is not available. .The formula will display #NA when it does not find the information that it is looking for.
Kutools for Excel, amazing!Click here for a tutorial.For this example well use a to indicate the value is not available, as for this particular exercise, well essentially assume countries that do not show up in the source data have a value.Step 7: Close out your IF Statement Finish your IF Statement with a final parenthesis.You also need to be careful about the number of parentheses you include when writing the formula, as making a mistake here is very easy. .Conclusion Using IF isna to mask errors is a popular trick to improve the visual output of your vlookup summaries. .Using IF isna with vlookup, objective : To write a vlookup formula returning multiple values while masking the #N/A error whenever it comes.After putting in the parenthesis, close out the logical_test with a comma.A:N6, 14, false 0).