C
Chuck N
I am trying to build a cross reference database for all of our par
numbers. Few questions first.
The database is setup similar to this. The first column (A) is th
internal part number and the manufacturer part numbers are column
(B-K). The list right now is roughly 1000 rows long. The name of th
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 an
paste a column of at least 50 part numbers to search the database an
return the Internal Part number value for it found in the database. I
would be ideal if I could return ALL of the values. What I mean is if
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 searche
for
numbers. Few questions first.
The database is setup similar to this. The first column (A) is th
internal part number and the manufacturer part numbers are column
(B-K). The list right now is roughly 1000 rows long. The name of th
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 an
paste a column of at least 50 part numbers to search the database an
return the Internal Part number value for it found in the database. I
would be ideal if I could return ALL of the values. What I mean is if
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 searche
for