How do I make a part number formula?

**Fastenal(FPAL)** · 04-22-2009, 12:15 PM

I'll try to keep this brief. Our part #'s look like this. XP014567. Where the first pair of characters stand for a value(say XP=Bolt), the second pair stand for a value(01= Grade 2), and so on. What I would like to be able to do is type in the part numer and have the description automatically populate. Is there an easy way to do this

? I'm running Excel 2003. Thanks!

Todd

**NBVC** · 04-22-2009, 12:25 PM

You would have to set up one or more tables that identify what each code and description is.. then use Vlookup() along with Left(),Mid(),Right() functions to extract those descriptions and then concatenate those results together...

e.g.

=Vlookup(Left(A2,2),table1,2,0)&" "&Vlookup(Mid(A2,3,2),table2,0)&" "&Vlookup(Right(A2,3),table3,2,0)

where table1, table2 and table3 are the 3 separate lookup tables..(named ranges or you can replace with specific references such as $X$1:$X$100, etc...)

**Fastenal(FPAL)** · 04-22-2009, 04:12 PM

Got it! Thanks!

Todd

**NBVC** · 04-22-2009, 04:14 PM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save