+ Reply to Thread
Results 1 to 2 of 2

VLookUp doesn't find an exact match even though FALSE is used as the last parameter.

  1. #1
    Registered User
    Join Date
    03-16-2005
    Posts
    20

    VLookUp doesn't find an exact match even though FALSE is used as the last parameter.

    Hi everyone,
    does anybody have an idea why VLookUp doesn't find an exact match even though FALSE is used as the last parameter?

    I have two formulas:

    =VLOOKUP("123","A:B",2,FALSE)

    and

    =VLOOKUP("1234","A:B",2,FALSE)

    The first formula finds value, but the second one doesn't.
    The left column ("A") is formated as TEXT and both LOOKUP_VALUES (123 and 1234) are presented in column "A".

    In other words, the formulas are almost the same, except that LOOKUP_VALUES (123 and 1234) are different.

    Thank you.
    surotkin

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Are you sure all of your entries in Col A are truly TEXT? "1234" is not the same as 1234.

    To check, use this formula in another cell:

    =ISNUMBER(A1) 'alter the cell reference to the one in question or place this in C1 and copy down the entire range. A 'TRUE' response means the contents of the target cell is NOT text.

    HTH
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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