2) Sample Data - Suggested UseUse this data to demonstrate lookup formulas, such as VLOOKUP, XLOOKUP, INDEX and MATCH. Also, you could show how to create dependent drop down lists, for category and food item. See the Excel Daily Calorie Counter page for an example. ...
In the sections below, you'll find Excel workbooks that you can download, to get insights on how functions, macros, and other features work. Some of the files have VBA code, so enable macros if you want to test those spreadsheets. You can also get my files with Excel data for practice...