I wonder if it's possible to use vlookup or some such function to call
and copy cells from a table.

I have a table such as:

product color units weight retails discount total cost

I want create a sheet where when I choose the product, the next cell
shows a dependent list of the available colors for the product
(something I think I already figured out), but then I'd like to copy
the adjacent cells, with formulas, from the product table. So if I
choose product A I get all the cells copied from that line to a form.

Hope that makes sense...and I really hope it's possible.

Thanks in advance,

Tanner