Forum Discussion
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...
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.