+ Reply to Thread
Results 1 to 12 of 12

VLOOKUP formula does not return expected value. Suspected error in formula. Returns N/A

  1. #1
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    VLOOKUP formula does not return expected value. Suspected error in formula. Returns N/A

    Hello

    I've attached a mirror image of a workbook im working on, i just removed and replaced data with generic examples.

    I am trying to do a vlookup where C4 on the 'MAIN' sheet looks at B4, looks it up in 'names & ID', finds it, and returns the corresponding value in the F column

    To be more specific i am expecting 'Customer 112' to be returned.

    I swear i have done the formula correctly but for whatever reason it returns N/A.

    I'm sure this is a common one and a common mistake.

    Formula used

    =VLOOKUP(B4,'Names & ID'!D2:F323,3,FALSE)
    Attached Files Attached Files
    Last edited by ZMAFC94; 07-31-2018 at 04:30 AM. Reason: Needed more detail for some reason.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: I can't do a simple VLOOKUP!!

    Try this;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,892

    Re: I can't do a simple VLOOKUP!!

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe your problem in detail, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,244

    Re: I can't do a simple VLOOKUP!!

    Deleted Post

  5. #5
    Registered User
    Join Date
    07-27-2018
    Location
    Newcastle
    MS-Off Ver
    2013
    Posts
    20

    Re: I can't do a simple VLOOKUP!!

    Try this

    =VLOOKUP(B4+0,'Names & ID'!D2:F323,3,FALSE)

  6. #6
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    Re: I can't do a simple VLOOKUP!!

    Thanks Ali, sure.. done.
    Last edited by ZMAFC94; 07-31-2018 at 04:20 AM.

  7. #7
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    Re: I can't do a simple VLOOKUP!!

    Thanks Mjmitch, this now works

    Can i ask what the B4+0 does?

    Trying to learn

    Thanks again

  8. #8
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    Re: I can't do a simple VLOOKUP!!

    Kersplash,

    Cheers - this also works.

    Can i ask what adding VALUE( did?

  9. #9
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: VLOOKUP formula not working

    Changes the text you are comparing to a number which is in your vlookup table.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,892

    Re: VLOOKUP formula not working

    Your title still is not adequate. Please change it to this:

    "VLOOKUP Returning #N/A Error Message - Unable to Work Out Why"

    This gives helpers a clue about the issue - do you see?

    Once this is done, I will release the response given already.

    @ Mjmitch - please read the forum rules regarding NOT responding to a thread where a moderation request is outstanding. Thanks.

  11. #11
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    Re: I can't do a simple VLOOKUP!!

    Detail as per instruction.
    I have what i need anyway, the two users were very helpful.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,892

    Re: VLOOKUP formula does not return expected value. Suspected error in formula. Returns N/

    Thanks. Please bear this instruction in mind for future thread titles.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. [SOLVED] A simple vlookup proving to be not so simple
    By dominicexcel in forum Excel General
    Replies: 9
    Last Post: 04-13-2018, 05:47 PM
  2. Just need a little help with simple vlookup
    By exced in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-15-2016, 05:16 PM
  3. [SOLVED] help with simple IF / VLOOKUP ?
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2015, 12:27 PM
  4. Simple vlookup
    By geddes_3 in forum Excel General
    Replies: 2
    Last Post: 10-28-2011, 11:55 AM
  5. How To Do Simple Vlookup?
    By doozidoesit in forum Excel General
    Replies: 10
    Last Post: 03-30-2011, 06:56 PM
  6. Simple Vlookup?
    By ringrim in forum Excel General
    Replies: 1
    Last Post: 08-20-2008, 01:38 PM
  7. Simple VLOOKUP...
    By compulsiveguile in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-16-2008, 09:10 AM

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