Results 1 to 51 of 51

vlookup avoiding #N/A

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2005
    Posts
    3

    vlookup avoiding #N/A

    Hi!

    If anybody know a way around this I'll be forever thankfull.

    I have a standard list which uses vlookup to another list which varies. If there is not a match I get #N/A and that messes up my subtotals in the first list. I have tried variations with if, match and find but I can not make it work.

    How can I get Excel to reply "" or 0 instead of #N/A?

    N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
    N2=FD312 Insurance

    Thanks in advance
    Last edited by Lillian Eik; 07-05-2005 at 12:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1