Results 1 to 6 of 6

Getting Rid of Vlookup #N/A Error Message

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2010
    Location
    Jamaica
    MS-Off Ver
    Excel 2003
    Posts
    92

    Getting Rid of Vlookup #N/A Error Message

    Greetings Evreryone,

    How can you write a VLOOKUP formula to prevent it from giving you an #N/A error message when it is unable to find the lookup value.

    For example: If i am looking for let say number 101 in column 'A" but there is no number one, how do i get the vlookup formula to return Zero (0) instead of #N/A.
    Last edited by headley4ever; 12-07-2010 at 07:25 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