Hi Tanner

A simple method would be to use Vlookup, taking the drop down cell for your
value to look up
--
Tony Green


"tanner" wrote:

Hi all,

I'm hoping someone can help. I have a sheet with a column where the
user selects a product from a drop down list. I want to be able to
match the selected value with a table on a seperate sheet and copy over
the matching row. The table has the product name, size, colors, weight,
etc. I need the values and the formulas of the row copied over as well.

Hope that makes sense.

T.