+ Reply to Thread
Results 1 to 11 of 11

Vlookup - Logical Error

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Vlookup - Logical Error

    Hi,

    I have been using vlookup quite a while. While I was creating a new formula, I faced with a strange result which I explained at attached excel sheet.
    Did I do it wrong?

    Thanks,
    Eric
    .
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Vlookup - Logical Error

    Change formula to

    =VLOOKUP(F4,A1:E14,2,FALSE)

    as FALSE returns exact match
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Vlookup - Logical Error

    Change your formula from TRUE to FALSE for an exact match:

    =VLOOKUP(F4,A1:E14,2,FALSE)

    - Moo
    Last edited by Moo the Dog; 07-18-2013 at 10:01 AM. Reason: Ace the speed demon strikes again.... =)

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Vlookup - Logical Error

    More information is needed...
    Will F4 ever be a decimal number (not an exact match to one of the values in column A)
    If so, what is the expectation, say F4 = 15.5, should the result be LeadDrafter1 or LeadDrafter2?

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Vlookup - Logical Error

    Double post, sorry.

  6. #6
    Registered User
    Join Date
    07-18-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Vlookup - Logical Error

    Thank you Moo and Ace_xl

  7. #7
    Registered User
    Join Date
    07-18-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Vlookup - Logical Error

    That was really fast. thank you all.

  8. #8
    Registered User
    Join Date
    07-18-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Vlookup - Logical Error

    I have another question related to 'vlookup' formula
    this time I lookup a text, but couldn't figure it out which settings should I use? I tried 'text' it didn't work.

    20.00 ExpertDrafter3 n/a 522108.00
    19.00 ExpertDrafter2 769247.00 572841.00
    18.00 ExpertDrafter1 625994.00 437278.00 Formula Gives below data
    17.00 LeadDrafter3 473006.00 387822.00 LeadDrafter1 #N/A
    16.00 LeadDrafter2 384491.00 278089.00
    15.00 LeadDrafter1 325489.00 237696.00 =VLOOKUP(F4,A1:E14,2,TRUE)
    14.00 ExpDrafter3 274832.00 185102.00
    13.00 ExpDrafter2 225471.00 160912.00
    12.00 ExpDrafter1 162169.00 118674.00 It should be 437278.00
    11.00 Drafter3 131767.00 89810.00
    10.00 Drafter2 117570.00 80487.00
    9.00 Drafter1 114451.00 69367.00
    8.00 EntryDrafter3 78069.00 58302.00
    7.00 EntryDrafter2 108003.00 59751.00
    Attached Files Attached Files

  9. #9
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Vlookup - Logical Error

    In your sample file which column do you want to get the result from? Column C or column D?

    To get the result from column C:

    =VLOOKUP(F4,B1:D14,2,0)

    To get the result from column D:

    =VLOOKUP(F4,B1:D14,3,0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  10. #10
    Registered User
    Join Date
    07-18-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Vlookup - Logical Error

    Thank you very much

  11. #11
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Vlookup - Logical Error

    You're welcome!

+ 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. IF Function-Logical Vlookup Error
    By Joy_Joy in forum Excel General
    Replies: 2
    Last Post: 09-13-2012, 08:45 AM
  2. Replies: 3
    Last Post: 07-25-2012, 09:32 AM
  3. [SOLVED] Can I add a third logical test to an if or vlookup formula?
    By excyclist in forum Excel General
    Replies: 3
    Last Post: 07-01-2012, 11:23 PM
  4. Unrecognisable logical error
    By PallaviPallavi in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-20-2012, 05:37 AM
  5. VLOOKUP and logical functions
    By Margherita in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2006, 10:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1