Hi

The part list must have part number column as leftmost.

Into cell where you want some sort of detailed info to appear, enter the
formula like this:
=VLOOKUP(PartNumber, PartsTable, ColumnNumber, 0)

where
PartNumber is the reference to cell in same sheet (row), where you
entered part number;
PartsTable is the reference to table, where all parts detailed info is
stored (NB! Remember - the leftmost column contains part numbers. And use
absolute reference, or dynamic named range for this);
ColumnNumber is the relative number of column in table PartsTable, where
searched info is stored.

For cases the part number you are looking for is missing in PartsTable, or
is mistyped, you can wrap all this into error checking - like
=ID(ISERROR(VLOOKUP(...)),"",VLOOKUP())


Arvi Laanemets


"Ginger" wrote in message
...
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!