anwarsafianCopper ContributorJul 09, 2024SolvedHow to simplify formula Hi Expert How to simplify formula in Inflow tab, column B. The formula are quite long and complex. I believe excel should be intelligent enough to simplify this Show MoreHow to simplify formula.xlsx58 KBHansVogelaarJul 09, 2024anwarsafian In B2: =XLOOKUP(A2, Ref!$A$1:$A$52, Ref!$C$1:$C$52, "", -1)
