Question: why is iferror returning 0?
Answer: Replies (1)  The formulas work provided that the value is found and the adjacent column to the found value (Referenced by Column Index Number) in the lookup array contains data. If the cell referenced by the Column Index Number is blank then zero is returned because that is the value of an empty cell.