Forum Discussion

yardarrat's avatar
yardarrat
Copper Contributor
Jul 16, 2021

Spill Range and XLOOKUP with complex criteria, one of which uses the # operator

macOS Big Sur 11.3.1 MacBook Air (M1, 2020)   Microsoft Excel for Mac Version 16.51   I have these two tables:   A2:D7 has the different VAT rates and the corresponding dates when they ...

Resources