Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.
Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated ...