Excel formula involving multiple nested functions, an error occurs

[SHAO-QII]

EPPlus usage

Noncommercial use

Environment

windows

Epplus version

7.1.3

Spreadsheet application

excel

Description

When calculating with an Excel formula involving multiple nested functions, an error occurs. The error happens after successfully retrieving the value of E7 from a subset of data, but then fails when attempting to retrieve E6. Despite this, Excel executes the formula without indicating any errors

formula ：
=IFERROR(LOOKUP(OFFSET(OFFSET(钢材库!$D$2:$D$102,MATCH(E6,钢材库!$M$2:$M$102,0)-1,0,COUNTIF(钢材库!$M$2:$M$102,E6),1),MATCH(E7,OFFSET(钢材库!$D$2:$D$102,MATCH(E6,钢材库!$M$2:$M$102,0)-1,0,COUNTIF(钢材库!$M$2:$M$102,E6),1))-1,0,1,1),OFFSET(钢材库!$D$2:$D$102,MATCH(E6,钢材库!$M$2:$M$102,0)-1,0,COUNTIF(钢材库!$M$2:$M$102,E6),1),OFFSET(钢材库!$E$2:$E$102,MATCH(E6,钢材库!$M$2:$M$102,0)-1,0,COUNTIF(钢材库!$M$2:$M$102,E6),1)),VLOOKUP(E6,钢材库!$C$2:$L$102,COLUMNS(钢材库!$C$2:$E$3),FALSE))

[JanKallman]

Can you attach the workbook that reproduces this issue.

[SHAO-QII]

ok！In the "阿姆斯图兹" worksheet, the strength values in row 13 need to be updated when the steel grade in row 6 is changed.

Test.zip

[JanKallman]

Works fine when I recalculates the workbook using EPPlus 7.2.