Forum Discussion
E_Sean_Sullivan
Oct 02, 2023Copper Contributor
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...
- Oct 02, 2023SWITCH is a good swap for IF/IFS to simplify logic. It seems like you have a lot more data. Have you considered using XLOOKUP?
Patrick2788
Oct 02, 2023Silver Contributor
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?
E_Sean_Sullivan
Oct 02, 2023Copper Contributor
Patrick2788 You are a steel-eyed missile man. Its exactly what I needed. Thank you for the education.
- Patrick2788Oct 03, 2023Silver ContributorYou're welcome!