+ Reply to Thread
Results 1 to 3 of 3

Vlookup returns #N/A

  1. 03-07-2014, 10:00 PM #1
    tsukami
    tsukami is offline
    Registered User
    Join Date
    02-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    13

    Vlookup returns #N/A

    I'll attach the document, but in the 'invoice worksheet', column D, the vlook up keeps returning n/a
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-07-2014, 10:14 PM #2
    ajob
    ajob is offline
    Registered User
    Join Date
    02-22-2014
    Location
    Wgtn NZ
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Vlookup returns #N/A

    When using vlookup you need to define the range by placing $ around the cell reference and row number e.g $A$6:$A$9.
    Reply With QuoteRegister To Reply
  3. 03-07-2014, 10:30 PM #3
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Vlookup returns #N/A

    =VLOOKUP(C4,Commission!$A$4:$B$7,2,FALSE)*F4

    and copied down
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to bring all vlookup returns even with duplicate vlookup search keys
    By NYC4LIFE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2013, 04:53 PM
  2. [SOLVED] Vlookup returns #NA
    By jewellove in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-26-2012, 09:23 AM
  3. Vlookup returns ###
    By JOGIER in forum Excel General
    Replies: 2
    Last Post: 03-18-2009, 04:05 PM
  4. vlookup returns #N/A
    By forcybo in forum Excel General
    Replies: 4
    Last Post: 11-12-2008, 06:12 AM
  5. [SOLVED] VLookup returns #VALUE!
    By BEEJAY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-08-2005, 10:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1