It is hard to give you a specific formula to use without having the actual data sheet, but I can give you a method you could use.
I'll give you an example of how to do this with a mock set up for your ingredient list.
Assume that your ingredient sheet looks like this:
| Item | KCAL | VET | VERZ |
|---|---|---|---|
| Carrot | cKCAL | cVET | cVERZ |
| Tomato | tKCAL | tVET | tVERZ |
etc. etc. and is named Ingredients.
In your lookup sheet that you posted in your question, you could set the formula in cell C3 to be the following:
=iferror(filter(Ingredients!B2:D22, Ingredients!A2:A22=A3:A23))
Please let me know if you have any trouble with this. Hope this helps!
