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!