+ Reply to Thread
Results 1 to 4 of 4

Lookup function doesn't work correctly?

  1. 06-17-2014, 02:34 AM #1
    csleong
    csleong is offline
    Registered User
    Join Date
    06-17-2014
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    16

    Lookup function doesn't work correctly?

    Please see the attached screenshot...1.png

    Or please tell me what's wrong...
    Reply With QuoteRegister To Reply
  2. 06-17-2014, 02:41 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Lookup function doesn't work correctly?

    Lookup always work correctly

    You need to have lookup vector in alphabetic order!

    Easiest way is to write your data in the column and sort them A-> Z.
    That order use in Lookup vector.

    In this case thats: "P-08";"P-10";"P14D";"P14W"

    Sort Result vector too by selecting both ranges (J33:L36) and sort by J column.
    Reply With QuoteRegister To Reply
  3. 06-17-2014, 02:46 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Lookup function doesn't work correctly?

    Rather try this.....

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 06-17-2014, 03:52 AM #4
    csleong
    csleong is offline
    Registered User
    Join Date
    06-17-2014
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    16

    Re: Lookup function doesn't work correctly?

    Okay, I got it. Thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Min if function doesn't work for earliest date lookup
    By alexcrofut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2014, 01:57 PM
  2. Read clipboard doesn't work correctly
    By marmotinchen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2011, 08:16 AM
  3. Excel 2007 : Ctrl v doesn't work correctly
    By risman in forum Excel General
    Replies: 2
    Last Post: 02-28-2010, 11:53 AM
  4. [SOLVED] Sorting numbers doesn't work correctly
    By GrammyEmmy in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-25-2006, 06:50 PM
  5. Function doesn't work correctly with protection on
    By BigDave in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2005, 03:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1