Hi,

I've just made a large list of data (all on one sheet) with four columns of info pertaining to each item in the list. The entire spreadsheet is formatted as text. I am now trying to create a calculator that will pull data from one of those columns based on the item chosen. For example:

This is a small sample of my list:

ITEM PROT CARB FATS CALORIES
Pineapple 5 5 5 15
Berries 8 8 8 24
Yogurt 3 3 3 9
Granola 4 4 4 12

What I want to achieve:

I am trying to be able to select random items that make up a recipe and have the calorie totals list out so I can get grand total calories for the entire recipe.

Basically.....

If I want to make a 'meal' of pineapple, granola and yogurt and find the total of the three, I want to go to a cell, type in pineapple and have 15 show up in the next cell automatically and I want to be able to do that with all three, or as many ingredients required to make a 'meal' or 'recipe' so that the totals show up and can be grand totaled at the bottom.

Hope that's not as clear as mud.

I tried using an "IF/THEN" scenario but I couldn't make it work. Such as.... "IF" I tell the new cell to equal the text in the cell that says Pineapple, "THEN" 15 shows up in the adjacent cell. And so on for each item in the list.

Help is greatly appreciated!!