Forum Discussion
Solved
LOOKUPVALUE: Expressions that yield variant data-type cannot be used to define calculated columns
Hi All This error message has been addressed in multiple posts, but I cannot seem to find a solution for my LOOKUPVALUE problem. I have two imported tables that I want to use a LOOKUP value D...
try this
ColName = LOOKUPVALUE ( Table2[Column2], Table2[Column1], Table1[Column1], 0 & "" )
try this
ColName = LOOKUPVALUE ( Table2[Column2], Table2[Column1], Table1[Column1], 0 & "" )
This works. Thank you