I am currently to add the ability for Excel to automatically fill in cells on
the spreadsheet I am creating based upon the information held within one cell.

My specific problem is that I have about 10 part numbers that I would like
to recall additional data for automatically wherever it appears. For example,
where a box with a particular part number appears I would like Excel to
recall data regarding that box, such as dimensions and weight, and place this
information on the cells to the right of that of the part number for the box.
The detailed information for the parts are already in Excel on another sheet
within the same file.

I was hoping that it would be fairly straightforward but I cannot find a way
of doing it without using IF statements and even then I am limited to only
being able to have 7 levels to it.

Any help would be greatly appreciated!