Forum Discussion
Solved
Vlookup doesn't work for inexplicable reason
I'm using a simple vlooukup, and in some cases although the lookup up value is in the first column in the table array, it can't find it. When i search manually for the searched value in the first col...
Domonkos , I guess that's rounding issue. If select your column C (and after that J), and Data->Text to Columns with Date and YMD on the third step of the wizard, that conversion rounds you date/time to seconds and VLOOKUP works. Please check in attached.
Some #N/A still exists, but it looks like really no matches.
Domonkos , I guess that's rounding issue. If select your column C (and after that J), and Data->Text to Columns with Date and YMD on the third step of the wizard, that conversion rounds you date/time to seconds and VLOOKUP works. Please check in attached.
Some #N/A still exists, but it looks like really no matches.
SergeiBaklan Thank you!