OK, I'm lost and confused!

Slightly.

I've figured out the VLookup, I think.

Vlookup Test Bed.xlsIngredients List.xls

But what I can't figure out is how to get it to fill in the gross and the unit.

Do I need to create separate formulas for those cells? Or can I encompass the whole thing in one big formula?