+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP Returning random Errors

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    VLOOKUP Returning random Errors

    Hello. Just joined here becuase I have a strange problem with VLOOKUP.

    I have workbook created that looks at data from two separate data logs. Each data log records the time and date, once per second, along with the series data needed. The data logs both run at the same time, but on different devices, so I have to coordinate the data together to look at it all at once..

    I am using VLOOKUP to use the timestamp from one datalog to coordinate the data from the second datalog. There are 2800 time stamps in my current file. Out of those, there are about a dozen places where the VLOOKUP function returns an error. When I look at the time stamps, they match exactly, just like all the other ones that return correct data. I have the ISERROR function in use also, to return a null cell in the event no data is available (this is to prevent problems at the end of the time series data, rather than showing a bunch of cells that say N/A)

    (I've also tried removing the ISERROR part and then the cells in question just return N/A anyway)

    Has anyone ever seen this type of problem?

    Here is the formula I am using in the cells "=IF(ISERROR(VLOOKUP(A334,PQA!AR$10:AS$4000,2,FALSE)),"",VLOOKUP(A334,PQA!AR$10:AS$4000,2,FALSE))"

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VLOOKUP Returning random Errors

    The values are surely NOT exactly the same. Post a workbook.
    Entia non sunt multiplicanda sine necessitate

+ 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