Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically populate and multiply amounts
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, |