lookup continues to iterate if a formula is invalid.