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!

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:

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!