Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel Vlookup only sometimes works

  1. #1
    Guest

    Default

    I am using VLookup on one tab to lookup data on another tab within the same spreadsheet. Some of the lookups work and some don't, even when I use the same values. As an example, I type 123 and get the correct answer. I try another cell and type 123 and get the right answer. Then I go back to the original cell and type 347 and get the right answer.

    I have double checked the following.

    1-The format of the cells in the table and lookup are identical.
    2-The table is sorted
    3-I've tried both True and False as the final parameter
    4- The range $A$2:$B$129 is the same for all the cells I looking for

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure that the lookup value and table values are not just formatted alike, but also of the same data type.

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
  •