Hi there,
Can you show me screenshots of your data?
Amanda
Hi there,
From the second picture, I don't see calories, protein, carbs, and fat values for the foods besides Bacond, cooked, so you cannot lookup the values for other foods in the green picture.
To get protein, carbs, and fat values for Bacond, cooked, you should make some of the cell references in the formula absolute by add the dollar sign ($). If you don't understand, please copy the formula in the intersection of Cal and Bacon, cooked.
And please, when you attach a picture, make sure the picture covers row numbers, column letters and formula bar as shown below:
[attachment]picture.png[/attachment]
Amanda
Hi there,
From the second picture, I don't see calories, protein, carbs, and fat values for the foods besides Bacond, cooked, so you cannot lookup the values for other foods in the green picture.
To get protein, carbs, and fat values for Bacond, cooked, you should make some of the cell references in the formula absolute by add the dollar sign ($). If you don't understand, please copy the formula in the intersection of Cal and Bacon, cooked.
And please, when you attach a picture, make sure the picture covers row numbers, column letters and formula bar as shown below:
[attachment]picture.png[/attachment]
Amanda
Hi, you should have applied validation restrictions on your cells. Follow the steps to clear them:
Select the cell or cells that you want to remove validation from.
Click Data > Data Tools > Data Validation.
Click the Clear All button.
Click OK.
Then please copy the formula in the cell D5 in the green table. If you cannot, take a screenshot of THE FORMULA IN D5.
Thanks.
Amanda