+ Reply to Thread
Results 1 to 3 of 3

Why I'm not getting correct output from lookup formula?

  1. 05-03-2015, 09:45 AM #1
    mso3
    mso3 is offline
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Why I'm not getting correct output from lookup formula?

    Hi friends,
    Please see the attached workbook and tell me why I’m not getting correct output by ‘Lookup’ formula.

    Thanking you,
    Attached Files Attached Files
    Sincerely,

    mso3
    Reply With QuoteRegister To Reply
  2. 05-03-2015, 09:48 AM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,481

    Re: Why I'm not getting correct output from lookup formula?

    Lookup_vector must be in increasing order. Try to sort BW column.
    Quang PT
    Reply With QuoteRegister To Reply
  3. 05-03-2015, 10:12 AM #3
    mso3
    mso3 is offline
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Why I'm not getting correct output from lookup formula?

    Hi bebo021999,

    Thank you. Problem solved after sorting the column in ascending order.

    Have a nice time.
    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. [SOLVED] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  2. [SOLVED] Formula error_no correct output
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2014, 10:09 PM
  3. [SOLVED] Formula not giving correct output
    By aakhan2011 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-24-2014, 03:21 AM
  4. [SOLVED] Error in sum formula not correct output
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2014, 11:40 AM
  5. LOOKUP does not always give the correct result - correct number of vectors etc checked
    By confusedcelt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2012, 09:35 AM

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