+ Reply to Thread
Results 1 to 5 of 5

VLOOKUP not working as expected.

  1. #1
    Registered User
    Join Date
    11-17-2013
    Location
    Knoxville, Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    13

    VLOOKUP not working as expected.

    I have been attempting to find the value in the sheet "Overview" in column A(storage location) that corresponds to the value in column C(ndc number). I am attempting to autofill the parts location on the sheet named "Orders". I am using the formula =VLOOKUP(H2,Overview!A:C,1,TRUE). It is not working the way I am expecting. What I need is if Orders!H2 = 1234 to find 1234 on Overview! and display the value of Column A on the line that contains 12345. The sheet named Orders, column K is where i need the formula. I have uploaded an anonymized version of the workbook. Any help would be greatly appreciated.

    Inventory Tracking A.xlsx

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: VLOOKUP not working as expected.

    this might help...

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: VLOOKUP not working as expected.

    So, let me get this straight, Orders!K2 is trying to pull in the Location depending on the Item Identifier used in Column H of Orders?

    You are not very clear and you need to provide a flat version of actuals you expect to happen with the correct formula, plus youa re talking about H2 in orders, that isnt even a formula.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  4. #4
    Registered User
    Join Date
    11-17-2013
    Location
    Knoxville, Tennessee
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: VLOOKUP not working as expected.

    @ judgeh59 That works perfectly! Thanks you so much! I have been beating my head against the wall all day trying to figure this out. +rep

  5. #5
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: VLOOKUP not working as expected.

    no problem.....my pleasure....glad I could help and thanks for the rep bump

+ 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. String not working as expected
    By WilyOne in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2011, 08:44 AM
  2. [SOLVED] IF statement is not working as expected?
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2009, 02:02 PM
  3. vlookup/if formula not working as expected
    By Shocked in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2008, 10:06 AM
  4. [SOLVED] For Each Statement not working as expected
    By Jacqui in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  5. [SOLVED] Lookup Not working as expected
    By trumpy81 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-30-2005, 03:05 PM

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