Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross Reference Part Numbers
I am trying to build a cross reference database for all of our part numbers. Few questions first. The database is setup similar to this. The first column (A) is the internal part number and the manufacturer part numbers are columns (B-K). The list right now is roughly 1000 rows long. The name of the sheet is Database. Int Part# | Man1 | Man 2 | Man 3 | -- Man 10 1 MEM-1 | 123 | 1-24 | 42-9 | SCK146 2 MEM-1 | 345 | 2-24 | 43-9 | SCK147 3 MEM-1 | 678 | 3-24 | 44-9 | SCK148 4 MEM-1 | 910 | 4-24 | 45-9 | SCK149 5 MEM-1 | 111 | 5-24 | 46-9 | SCK150 On a seperate sheet named SearchSheet I need to be able to copy and paste a column of at least 50 part numbers to search the database and return the Internal Part number value for it found in the database. It would be ideal if I could return ALL of the values. What I mean is if I search for the value 45-9 exactly it will return MEM-1 | 123 | 1-24 | 42-9 | SCK146 in columns (B-L) of the same row as the part I searched for. -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=562270 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross Reference Part Numbers
anyone have some ideas? -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=562270 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross Reference Part Numbers
ANY tips? -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=562270 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Vlookup referencing one column that contains part numbers in both. | Excel Worksheet Functions | |||
Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
How do I locate a highlighted cell as a cross hair type reference | Setting up and Configuration of Excel | |||
Cross Reference of Excel Workbook | Excel Discussion (Misc queries) |