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