Hello Everyone,
I've been searching for an answer on this for a while today but have yet to find a fix. the arrays and lookup are formatted at number but I'm still have an NA error.
Attached is my workbook, the formula is in sheet “KALK column AI. I’m trying to match the value in AH in the table in sheet “ELEV” column “H”. Both columns are in number format, but only 0 is recognized.
What am I doing wrong? This is a bit embarrassing.
Thanks in advance.
Bookmarks