I have a worksheet filled with GPS data (84k lines). From another page, I used VLOOKUP to find the location. The problem I am having is that I have no clue how Excel is formatting the data. Both time columns are formatted as TEXT. I do this so it will sort my data correctly even if there are leading zeros or odd seconds (e.g. 0944, 095230, 1000, 1005 would be sorted correctly).
In 151 samples, Excel found exactly one match from the GPS table. I am guessing that there is some "correct" format in that cell, though do not know why it would be different than the rest of the column (all entered manually).
If I paste a time from the GPS page, it does the VLOOKUP correctly with ostensibly the exact same text string "164345." Both pages show these as being formatted as "Text," I can find no spaces or anything that confuse the comparison.
Formula: =VLOOKUP(AA4,GPS_data,4,0) Return : #N/A Even when a match is obviously present in the GPS_data array.
How can I find out what Excel sees when it is trying to read this cell, AA4? And why it does't match the exact same string in the lookup array most of the time?
Thanks for any insights.
Bookmarks