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):

Publish by

1 comment:

  1. UnknownSeptember 6, 2011 at 4:18 PM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)