Forum Discussion

PFoleyPEP's avatar
PFoleyPEP
Copper Contributor
Aug 21, 2026

Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument?

In the formula below, expensiveMatch is defined in LET but only referenced as IFNA's fallback argument: =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sh...