Tagging Data Cells - Flags, VLOOKUP, Tag, Cytokines

[Chrisdudley7]

I have a cell of data for example 'lean beef' - but I want to tag it with something that I can calculate later say '1 oz of lean beef' - since I figure I can't calculate 'lean beef' but I could calculate '1 oz' how do I attach this descriptor? Also, let's say I want to tag it as 'Dinner' as well

So 'lean beef' is just one datum - I plan on doing this for lots of other foods that will have their own cells and will fit into multiple variables - in different categories (Meat, Fruit, Fats, etc) with different meal categories (Dinner, Lunch, Breakfast, Snack) and all of which have different measurements (oz, cup, quantity, etc). How can I make a manipulable data set that captures all this information? Is this what VLookup is? Is there a way to do this with pivot tables?

 

[Gimics]

Hey Chris,

It sounds like you need to create a data table of foods to house your variables, which you can then access later using some kind of lookup or reference function (vlookup, index, match, etc.). Your starting point is to build a spreadsheet with a master list of foods/items/products/whatever and then columns for each of the unique variables you would like to store (unit of measure, measurement, categories, meal categories, etc.). From this, we can help you with a formula to look up the variables you need, when you need them.