OK, the board has been extremely helpful thus far, so I've decided to shoot
another question out there.

We have lists of different products in one tab of a worksheet. We are
trying to set up another worksheet that will allow us to input the item
number and have it A) pull in all the info from the other sheet in the column
for that item number and B) multiply the individual ingredients by the amount
of the product that we need. I was going to input a bunch of vlookup
formulas into each cell to have it pull in the appropriate amounts, but I
think there is probably a better way to do this.

Any input?

Thanks,