software

I am creating a sheet that lists various assembly components (part number amp;
part description - in two separate columns), and I would like to be able to
enter in the part number, and have Excel automatically fill in the part
description based on that part number. The list I am creating uses many
parts over and over again for several assemblies, so it would save valuable
time if I could streamline this process.

Is there a way I could have some sort of master list, where all part numbers
are listed with their associated descriptions, and use that as a reference?

Try this:

Put a new worksheet in your workbook, then:
A1: PartNum
B1: PartDesc
A2: PartNum_A (or whatever products you have)
B2: Description of PartNum_A
Continue filling in the list

When done...
Select from A2 through the last item in Col_B
Insertgt;Namegt;Define
Name in workbook: LU_PartInfo
Refers to: (your already selected list)
Click the [OK] button

Next, switch to your input sheet
Select the PartNum input cells
Datagt;Validation
Allow: List
Source: =OFFSET(LU_PartInfo,0,0,,1)
Click the [OK] button

Select the PartDesc cells (I'll assume they begin in cell B2)
B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_PartInfo,2,0))
Copy that formula down as far as you need.

Results:
The PartNum input cells will only allow valid products.
The Part Description cells will lookup each product in the LU_Partinfo list
and return the corresponding description.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP-Proquot;djDaemonquot; wrote:

gt; I am creating a sheet that lists various assembly components (part number amp;
gt; part description - in two separate columns), and I would like to be able to
gt; enter in the part number, and have Excel automatically fill in the part
gt; description based on that part number. The list I am creating uses many
gt; parts over and over again for several assemblies, so it would save valuable
gt; time if I could streamline this process.
gt;
gt; Is there a way I could have some sort of master list, where all part numbers
gt; are listed with their associated descriptions, and use that as a reference?

That's close. Eventually, perhaps the validation of part numbers could be a
reality, but until the list is completely populated I would still need to
enter in additional non-validated numbers. Of course, I could enter the
parts into the reference list beforehand, having left room for future entries
in that list.
quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Put a new worksheet in your workbook, then:
gt; A1: PartNum
gt; B1: PartDesc
gt; A2: PartNum_A (or whatever products you have)
gt; B2: Description of PartNum_A
gt; Continue filling in the list
gt;
gt; When done...
gt; Select from A2 through the last item in Col_B
gt; Insertgt;Namegt;Define
gt; Name in workbook: LU_PartInfo
gt; Refers to: (your already selected list)
gt; Click the [OK] button
gt;
gt; Next, switch to your input sheet
gt; Select the PartNum input cells
gt; Datagt;Validation
gt; Allow: List
gt; Source: =OFFSET(LU_PartInfo,0,0,,1)
gt; Click the [OK] button
gt;
gt; Select the PartDesc cells (I'll assume they begin in cell B2)
gt; B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_PartInfo,2,0))
gt; Copy that formula down as far as you need.
gt;
gt; Results:
gt; The PartNum input cells will only allow valid products.
gt; The Part Description cells will lookup each product in the LU_Partinfo list
gt; and return the corresponding description.
gt;
gt; Is that something you can work with?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;djDaemonquot; wrote:
gt;
gt; gt; I am creating a sheet that lists various assembly components (part number amp;
gt; gt; part description - in two separate columns), and I would like to be able to
gt; gt; enter in the part number, and have Excel automatically fill in the part
gt; gt; description based on that part number. The list I am creating uses many
gt; gt; parts over and over again for several assemblies, so it would save valuable
gt; gt; time if I could streamline this process.
gt; gt;
gt; gt; Is there a way I could have some sort of master list, where all part numbers
gt; gt; are listed with their associated descriptions, and use that as a reference?



quot;djDaemonquot; wrote:

gt; That's close. Eventually, perhaps the validation of part numbers could be a
gt; reality, but until the list is completely populated I would still need to
gt; enter in additional non-validated numbers. Of course, I could enter the
gt; parts into the reference list beforehand, having left room for future entries
gt; in that list.
gt;
gt;
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; Put a new worksheet in your workbook, then:
gt; gt; A1: PartNum
gt; gt; B1: PartDesc
gt; gt; A2: PartNum_A (or whatever products you have)
gt; gt; B2: Description of PartNum_A
gt; gt; Continue filling in the list
gt; gt;
gt; gt; When done...
gt; gt; Select from A2 through the last item in Col_B
gt; gt; Insertgt;Namegt;Define
gt; gt; Name in workbook: LU_PartInfo
gt; gt; Refers to: (your already selected list)
gt; gt; Click the [OK] button
gt; gt;
gt; gt; Next, switch to your input sheet
gt; gt; Select the PartNum input cells
gt; gt; Datagt;Validation
gt; gt; Allow: List
gt; gt; Source: =OFFSET(LU_PartInfo,0,0,,1)
gt; gt; Click the [OK] button
gt; gt;
gt; gt; Select the PartDesc cells (I'll assume they begin in cell B2)
gt; gt; B2: =IF(ISBLANK(A2),quot;quot;,VLOOKUP(A2,LU_PartInfo,2,0))
gt; gt; Copy that formula down as far as you need.
gt; gt;
gt; gt; Results:
gt; gt; The PartNum input cells will only allow valid products.
gt; gt; The Part Description cells will lookup each product in the LU_Partinfo list
gt; gt; and return the corresponding description.
gt; gt;
gt; gt; Is that something you can work with?
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;djDaemonquot; wrote:
gt; gt;
gt; gt; gt; I am creating a sheet that lists various assembly components (part number amp;
gt; gt; gt; part description - in two separate columns), and I would like to be able to
gt; gt; gt; enter in the part number, and have Excel automatically fill in the part
gt; gt; gt; description based on that part number. The list I am creating uses many
gt; gt; gt; parts over and over again for several assemblies, so it would save valuable
gt; gt; gt; time if I could streamline this process.
gt; gt; gt;
gt; gt; gt; Is there a way I could have some sort of master list, where all part numbers
gt; gt; gt; are listed with their associated descriptions, and use that as a reference?