+ Reply to Thread
Results 1 to 6 of 6

Vlookup Issues

  1. #1
    Registered User
    Join Date
    05-11-2012
    Location
    AZ
    MS-Off Ver
    Excel 2003
    Posts
    15

    Vlookup Issues

    I have a vlookup that is searching for product numbers in a separate workbook that has a list of product numbers and their shipping box dimensions. MOST of the product numbers were found by the vlookup, but for some reason it skipped over many, even after I checked to make sure they were in fact in the other book. Maybe it's a formatting issue? In the spreadsheet "shipping example" I have a vlookup in B92 that returns NA. I feel like I'm doing something wrong, but I can't quite figure out what it is. I'm sure it's something easy, but it's driving me up the walls! If anyone can check it out and help me figure out what's going on, it would be much appreciated.

    =VLOOKUP(B92,[pricingandboxes.xlsx]Sheet1!$A:$B,2,FALSE) is what's in B92 on shipping example.

    pricingandboxes.xlsx

    shipping example.xlsx

    Let me know if you need more info.

    Again, thank you!
    Attached Files Attached Files
    Last edited by AndianAtWork; 05-03-2013 at 12:47 PM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Vlookup Issues

    It is Format issue.

    In Shipping sheet B92 the"number" is 691210. Format is General.In pricingandboxes sheet, column A the "numbers" have TEXT format. So if you type in this column A(lets's say in a3), 691210 and use in an empty cell, this formula

    =A3='[shipping example-2.xlsx]dimstobedone'!$B$92

    The answer will be FALSE.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Vlookup Issues

    Hi Andian,

    The numbers which are in Pricingandboxes are stored as Text convert all to numbers format and it is working now for me. Try and let me know if you need more clarification

  4. #4
    Registered User
    Join Date
    05-11-2012
    Location
    AZ
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Vlookup Issues

    I just got to work. I'll give these a try now and update with results. Thank you both so much!

  5. #5
    Registered User
    Join Date
    05-11-2012
    Location
    AZ
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Vlookup Issues

    I just got it to work. Thank you both very much! The formatting was being a bit of a pain and didn't want to change for whatever reason, but I got it.

  6. #6
    Registered User
    Join Date
    04-29-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Vlookup Issues

    Happy learning!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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