Forum Discussion

E_Sean_Sullivan's avatar
E_Sean_Sullivan
Copper Contributor
Oct 02, 2023
Solved

Need a wildcard for cell row reference.?

Sorry for the lack of knowledge and bad coding. I am building a customer database, sales tracking, inventory managing spreadsheet (Yeah I know). I am looking to clean up the code to auto populate the...
  • Patrick2788's avatar
    Oct 02, 2023
    SWITCH is a good swap for IF/IFS to simplify logic. It seems like you have a lot more data. Have you considered using XLOOKUP?