Forum Discussion

RMV's avatar
RMV
Icon for Helper V rankHelper V
8 years ago
Solved

LOOKUPVALUE returns blank value

Hi,   I'm facing a problem where i use lookupvalue formula with 2 values and returns blank value, and need help on this. I have 2 tables, with following samples   Table #1 Asset_no     Date    ...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    it's really weird, but your example works fine on my pc, no joins between the tables

    are both tables' data types the same? Other than that I cannot think of a reason for it not working on your side

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

it's really weird, but your example works fine on my pc, no joins between the tables

are both tables' data types the same? Other than that I cannot think of a reason for it not working on your side

  • RMV's avatar
    RMV
    Icon for Helper V rankHelper V
    8 years ago

    sorry, i have found the problem.

    tried to delete this post, but can't since a reply has been posted.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi RMV,

      You can share your solution, and mark it as answer. So more people will find workaround clearly.

      Best Regards,
      Angelia