Wednesday, May 4, 2011

Usefull VLOOKUP formulas without "#N/A"

If you are using VLOOKUP function you know the result "#N/A". To avoid this result you can return "0" (zero) or " " (empty space):

1 comment:

  1. You can also use IFERROR function in Excel 2007/10
    =iferror(vlookup(...);"")

    ReplyDelete