Forum Discussion
RMV
8 years agoHelper V
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 ...
- 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
8 years agoCommunity Champion
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
8 years agoHelper V
sorry, i have found the problem.
tried to delete this post, but can't since a reply has been posted.
- v-huizhn-msft8 years agoMicrosoft Employee
Hi RMV,
You can share your solution, and mark it as answer. So more people will find workaround clearly.
Best Regards,
Angelia