Apr 13 2019 07:53 AM
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 column and comper whether it is equal to the lookup value it says true. So it supposed to find it, however it says "#N/A".
Apr 13 2019 08:45 AM
Solution@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.
Apr 13 2019 08:45 AM
Solution@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.