Forum Discussion
chellpish
Sep 25, 2019Copper Contributor
Excel VLOOKUP function missing REF
I'm pulling an excel from online and I'm trying to figure out why the formulas work, but don't calculate. When I go to NAME MANAGER, I see that I am missing something: "='INPUT DATA'!#REF!" -more or...
chellpish
Sep 25, 2019Copper Contributor
it's because of a compatibility thing with lotus.
::facepalm::
now I just have to figure out how to rewrite the formulas to reference the underscored table names.
::facepalm::
now I just have to figure out how to rewrite the formulas to reference the underscored table names.