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!

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!

Ginger -
Take a looke at VLOOKUP() and HLOOKUP() in the help menu.

--
Regards,
Dave


"Ginger" wrote:

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!

Say that you enter the part number in A1 of Sheet1, and you wish to display
all the information about this part along Row1, from B1 to G1.

Sheet2 contains your data list, from H1 to N11
Say the list has the P/N in Column H, from H2 to H11,
And the rest of the list is in I2 to N11, with labels in Row1.

Enter this formula in B1 of Sheet1:

=IF(ISNA(MATCH($A$1,Sheet2!$H$2:$H$11,0)),"No
Match",VLOOKUP($A$1,Sheet2!$H$2:$N$11,COLUMN(B:B), 0))

Click the "fill handle" and drag this formula to G1 to copy.


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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!

Ginger Wrote:
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!

Hi Ginger

Try VLOOKUP or HLOOKUP functions dependant on the layout of your data

eg =VLOOKUP(PartNumber,A1:B1,2)

PartNumber - can be a cell reference or the actual number

A1:B1 - Range where additional Info is held, ie the other workbook

2 - Column No counting from left, where the data you want returned is
within the previous range

Ypu need to change this to suit your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401159

Thanks everyone for your helpful responses, I will have a play with VLOOKUP
and HLOOKUP and see how it goes.

Thanks again,

Ginger.

"Ginger" wrote:

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!