+ Reply to Thread
Results 1 to 7 of 7

When using vlookup why are some of the values coming up as N/A when the data is correct

  1. #1
    Registered User
    Join Date
    09-28-2021
    Location
    Vancouver
    MS-Off Ver
    Google Sheets
    Posts
    3

    When using vlookup why are some of the values coming up as N/A when the data is correct

    Hi,

    I don't understand why some of the values are showing the data but others are coming up as N/A. I noticed on those that said N/A if I changed the end of the formula to TRUE (instead of False) a value appears - although not the correct value.

    Here is the formula I am using:

    =vlookup(A3,'Active SKU'!B1:G,2,FALSE) and also tried =vlookup(A3,'Active SKU'!B1:G137,2,FALSE)

    Appreciate and help (and again I am very new to this so if you could explain it in layman's terms I would be very greateful)

    Thank you!
    Last edited by beesutts5445; 09-29-2021 at 04:01 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,536

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    =vlookup(A3,'Active SKU'!B1:G,2,FALSE)
    You are missing the bottom row in column G: B1:Gxx
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-28-2021
    Location
    Vancouver
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    I tried that and it didn't seem to work

  4. #4
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore/China
    MS-Off Ver
    H&B 2016
    Posts
    1,150

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    Did you fix the row? VLOOKUP(A3,'Active SKU'!B$1:G$XX,2,FALSE)

  5. #5
    Registered User
    Join Date
    09-28-2021
    Location
    Vancouver
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    YESSS!! Thank you! Can I ask... what do the $ signs do? I want to make sure I can learn for next time

  6. #6
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,201

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    Shot List

    B3=IFERROR(VLOOKUP('Shot List'!$A3,'Active SKU'!$B$2:$G$200,2,FALSE),"")

    Copy down

  7. #7
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore/China
    MS-Off Ver
    H&B 2016
    Posts
    1,150

    Re: When using vlookup why are some of the values coming up as N/A when the data is correc

    This is the relative and absolute cell address.

    The $ sign is to fix the row or column number so that when you copy down or across, the row or column number will stay the same.

    in your example say, A1=VLOOKUP(A3,'Active SKU'!B$1:G$100,2,FALSE), if there is no $ sign and you copy down the formula to cell A2, the formula will change to VLOOKUP(A3,'Active SKU'!B2:G101,2,FALSE)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run VLOOKUP only for data coming from a particular source
    By sb212410 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2017, 05:37 PM
  2. [SOLVED] Vlookup not returning correct values
    By jacobj12 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-21-2016, 10:56 AM
  3. [SOLVED] How to ensure the coming data is correct?
    By freeSky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-21-2012, 05:45 AM
  4. Why are my averages not coming out correct?
    By Onestopfanshop in forum Excel General
    Replies: 0
    Last Post: 07-19-2009, 10:29 PM
  5. Values not coming in few cell but coming in rest all cells
    By rashmib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 11:19 AM
  6. Totals not coming out correct.
    By Shadow-Warrior in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-18-2008, 03:20 PM
  7. Date Not coming into my XML file correct
    By jakebcmg in forum Excel General
    Replies: 0
    Last Post: 08-27-2008, 01:49 PM

Tags for this Thread

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