First point - they are called Cells, not boxes !!

Depending on how your main data is organised, you can do this with
VLOOKUP or you might have to use an INDEX / MATCH combination - check
them out in Excel Help.

Pete

On Apr 25, 12:16*pm, Frazospazo
wrote:
I'm trying to create a spreadsheet where; when an item is selected from the
drop down I created; the selected boxes will show the correct information for
that product.

Basically; when I click an object from the drop down list, I want it to then
show the Product number and barcode in seperate boxes...

Any ideas?