Forum Discussion

Domonkos's avatar
Domonkos
Copper Contributor
Apr 13, 2019
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 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". 

excel
Formulas and Functions
vlookup
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 13, 2019

    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.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 13, 2019

    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.

Resources