Array formula evaluates correctly but doesn't populate cell

**Leon V (AW)** · 08-06-2019, 07:03 AM

I have the following formula in a column called required lead time.

Formula:

Please Login or Register  to view this content.

What it should do is look at the table of drawing numbers compare that to it's parents list and where there is a match return the lead time number then take the maximum of those.
I have tested it on a dummy sheet and it worked.
on my main sheet though I can step into the evaluation and step by step everything goes correctly yet it still returns 0 no matter the inputs to the final iferror e.g. =IFERROR(32,0) becomes 0

**SjMaxwell** · 08-06-2019, 08:26 AM

I don't use arrays very much, but I think the Iferror has to be inside the Max formula to work with the array. AbleBits has an entry about Iferror function and it shows a simple Sum formula with the Iferror inside the Sum. Maybe worth a try...?
https://www.ablebits.com/office-addi...array-formulas