2) Sample Data - Suggested Use Use 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. Seethe Excel Daily Calorie Counter pagefor 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...