Hi!
I'm working on an Excel VBA program and I'm at a point where I'm trying to reduce typing for data entry staff by allowing them to type in a part number and I will automatically insert the description or part name for them. No problem with that at all. It's been working perfectly. However, now I'm finding out that in some instances, the original part number has been issued a NEW part number and in some cases, staff aren't aware that a part number has changed.
I've created a "lookup table" and using vLookup, as soon as the part number is entered, the part description is inserted. What I want to do within the lookup process is take a quick look at the replacement part number field to see if the entered number is now obsolete and should be changed. If it has a replacement number, I want to be able to now change the number the person originally entered with the replacement number and still enter autofill the part description as well.
Can that be done within my vLookup function and if so, how would I go about it?
Here is a small portion of the parts lookup table. As you can see, not all parts have replacement numbers.
[TABLE="width: 471"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Part No[/TD]
[TD]Part Name[/TD]
[TD]Replacement[/TD]
[/TR]
[TR]
[TD]2412b[/TD]
[TD]Tile Modified 1 x 2 Grille with Bottom Groove[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2420[/TD]
[TD]Plate 2 x 2 Corner[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2445[/TD]
[TD]Plate 2 x 12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2460[/TD]
[TD]Tile 2 x 2 with Pin[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2540[/TD]
[TD]Plate 1 x 2 with Handle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2555[/TD]
[TD]Tile 1 x 1 with Clip[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2879c01[/TD]
[TD]Train Wheel 9V Pair on Axle[/TD]
[TD]2878c91[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions for how I could accomplish this?
Thanks in advance,
Gary Rantz
I'm working on an Excel VBA program and I'm at a point where I'm trying to reduce typing for data entry staff by allowing them to type in a part number and I will automatically insert the description or part name for them. No problem with that at all. It's been working perfectly. However, now I'm finding out that in some instances, the original part number has been issued a NEW part number and in some cases, staff aren't aware that a part number has changed.
I've created a "lookup table" and using vLookup, as soon as the part number is entered, the part description is inserted. What I want to do within the lookup process is take a quick look at the replacement part number field to see if the entered number is now obsolete and should be changed. If it has a replacement number, I want to be able to now change the number the person originally entered with the replacement number and still enter autofill the part description as well.
Can that be done within my vLookup function and if so, how would I go about it?
Here is a small portion of the parts lookup table. As you can see, not all parts have replacement numbers.
[TABLE="width: 471"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Part No[/TD]
[TD]Part Name[/TD]
[TD]Replacement[/TD]
[/TR]
[TR]
[TD]2412b[/TD]
[TD]Tile Modified 1 x 2 Grille with Bottom Groove[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2420[/TD]
[TD]Plate 2 x 2 Corner[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2445[/TD]
[TD]Plate 2 x 12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2460[/TD]
[TD]Tile 2 x 2 with Pin[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2540[/TD]
[TD]Plate 1 x 2 with Handle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2555[/TD]
[TD]Tile 1 x 1 with Clip[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2879c01[/TD]
[TD]Train Wheel 9V Pair on Axle[/TD]
[TD]2878c91[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions for how I could accomplish this?
Thanks in advance,
Gary Rantz