Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Education please on V or H Lookup False?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is the purpose for using a false value with the lookups?

    [ This Message was edited by: Carl B on 2002-03-01 23:02 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    VLOOKUP & HLOOKUP formulas can give you misleading results if the target you are searching for is not in your list. For example Vlookup searches from the top of your list downwards, if it can't find your target it may give you the result of the nearest it can get to it - and you will be unaware this is incorrect. Also the list must be in sequential order, alphabetical and numerical or lookup will fail and give you a false result.
    However, if you add "false" at the end of the list of arguements these formulas will return an error result if they cannot find an exact match. This is better than false information and allows you to devise strategies to deal with it.
    Hope this helps
    Regards
    Derek

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,639
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-01 22:59, Carl B wrote:
    What is the purpose for using a false value with the lookups?

    [ This Message was edited by: Carl B on 2002-03-01 23:02 ]
    Carl,

    This from the Help file on the VLOOKUP worksheet function is the key to when to use or not to use FALSE (or 0) in VLOOKUP formulas:

    "If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted."

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •