+ Reply to Thread
Results 1 to 4 of 4

Vlookup help needed ASAP!

  1. #1
    Registered User
    Join Date
    New York
    MS-Off Ver
    MS Office Professional Plus 2013

    Vlookup help needed ASAP!

    I struggle big time with Vlookup. I just started in a position using Excel and I swear it has only worked 1/5,000 times :-( so frustrated right now and hating Excel. Here's the situation:

    First sheet:
    List of ee numbers (column B2)
    Goal: Match the ee numbers up with their correct dept mgr

    Second Sheet:
    Table array is Sheet2!B:E (aka highlighting the ee numbers up to the dept mgr)
    Column index: 4
    Range lookup: FALSE

    End result: NA straight down the line, wahhh :-(

    I made sure everything was formatted as general, even played around with concerting the ee #'s to #. Nothing works. I really, really appreciate any guidance and support you can provide?

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013

    Re: Vlookup help needed ASAP!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.


  3. #3
    Forum Contributor
    Join Date
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016

    Re: Vlookup help needed ASAP!

    Hi Freedom041984,

    Try this in column C on first sheet and drag down column:

    Please Login or Register  to view this content.
    Austin, Texas

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home

    Re: Vlookup help needed ASAP!

    if after what bigroo gave you it still doesn't work, the problems could be the range he put in the formula, if so change =VLOOKUP(B2,Sheet2!$B$2:$E$6,4,0) to this =VLOOKUP(B2,Sheet2!$B:$E,4,0) or another acceptable range OR you could have what looks like numbers in one cell but are actually text and numbers in another cell or hidden spaces. To test for that simply find a value in one sheet that you believe matches in the other sheet and use something like this for example... =B2=B26 if the values look the same but that formula returns false then one of the two might be text while the other is a number or one of them might contain a hidden space. You can test those options out by using =isnumber(b2) or =istext(b2)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Copy & Paste Help needed ASAP!!
    By Freedom041984 in forum Excel General
    Replies: 3
    Last Post: 02-22-2016, 11:48 AM
  2. [SOLVED] Count in series with multiple conditions
    By IslasLorax in forum Excel General
    Replies: 6
    Last Post: 03-28-2012, 01:02 PM
  3. genius needed asap!
    By jbaich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2011, 06:41 PM
  4. Help needed asap please!
    By magic2008 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2008, 08:26 AM
  5. ASAP HELP NEEDED ranges for a tax bracket
    By ifstatement in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2006, 11:33 PM
  6. Major Help Needed Asap
    By ninjashadow80 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2006, 11:59 PM
  7. Vlookup Help needed ASAP
    By Vladimir in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-15-2005, 05:05 PM

Tags for this Thread


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