Forum Discussion
using the Hlookup but get problem. the warming window jumped up
i am using the Hlookup formula: it's on below, don't know where has the problem as i am not the first time to use it. and those are no problems. why this has problem? the warming windows shows this f...
excel-headache , you missed one quote here
Working with such constants hardcoded into the formula is always source of errors. Much better to use ranges instead of constants (and in this case numbers instead of texts). You test your formula ones and after that it works, you have quite low chances to put wrong data in to the cell which crashes the formula.