How do I convert a phrase into a part number

[rxanuka]

I have been searching for 2 days and can't figure this one out. I am a
newbie to excel.

Please HELP!

If A2= "Muffler 90 wieght" then B2= "Part 169"
If A2= "Brake Pad 180 weight" then B2= "Part 170"
etc.................
I have 69 different parts and 69 coresponding numbers.

what is the formula for this?

Thanks,
Anuka

 

[Frank Kabel]

Hi
use VLOOKUP for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[rxanuka]

thanks Frank, but you may have weel given me a link for www.china.com


I am frustrated and that link didn't help me at all.
thakns,
Anuk

 

[Debra Dalgleish]

Assuming you have a list of part and part numbers in your workbook --

Give a name to the list --
Select the cell(s) to be named
Click in the Name box, to the left of the formula bar
Type a one-word name for the list, e.g. PartList.
Press the Enter key.

To return a part number from the list --
Select cell B2
Enter the formula: =VLOOKUP(A2,PartList,2,0)

Copy the formula down to the last row of data.

 

[Frank Kabel]

Hi
sorry for that. I hope Debra's follow-up has clarified the usage of
VLOOKUP for you. If not just post back

 

[rxanuka]

I am still 100% lost. Maybe I am retarded or did not make it clear.

I have column A

If I type in the name of a part, I want the part # to spit out int
column B.

Example.

A2= Brakes

then automatically it spits out "Part #128" in B2

but I can enter 70 different parts.

so if I entered Wheels in A2 instead of Brakes it would give me
different part #. there is 70 parts total, so 70 different outcomes.

thanks,
Anuk

 

[Myrna Larson]

YOu need to create a 2-column list to serve as a lookup table. The first
column should have the words like GBrakes, Wheels, etc. The 2nd column should
have the corresponding part number. It would look like this

Brakes Part #128
Wheels Part #130

etc. Let's say that table is on sheet2, cells A1:B70

Then the formula for B2 on the first sheet is

=IF(A2="","",VLOOKUP(A2,Sheet2!$A$1:$B$70,2,0))

 

[Domenic]

On Sheet 2, set up a table similar to this one...

Part | Part Number
Muffler 90 Weight | Part 169
Brake Pad 180 Weight | Part 170
etc...

On Sheet 1, enter the name of the part you're interested in A2, an
enter the following formula in B2:

=VLOOKUP(A2,Sheet2!A2:B100,2,0)

Adjust the range for your table accordingly.

Hope this helps

 

[Frank Kabel]

Hi
first you have to start creating a table which stores your associated
values. That is in column A the part names and in column B the part
number. this you have to do as preparation. Afterwards you can use
VLOOKUP as explained and shown in the link I provided to you.

You somehow have to tell Excel which part# belongs to which part name

 

[rxanuka]

ok great, I got it!!!


thank you so very much..
-Anuk