Use VLOOKUP:
On sheet1 in B2:
=VLOOKUP(A2,sheet3!A:C,2,0) will retrieve Description
in C2:
=VLOOKUP(A2,sheet3!A:C,3,0) will retrieve Price

A2=Item #

A:C in Sheet3 contain Item #, Description & price

HTH


"Susan" wrote:

I've created drop box for my project--I need to have all relevant info to
automatically carry over as well.

In sheet 3 i have my lists: Item#, Description, Price (all in seperate
cells)
In sheet 1 i have the dropdown set up.

When I select an Item number, how do I make sure the description and price
automatically carry over with it in their respective cells?

Thank You

Susan Christenson