Spreadsheet 1 has A = CusPN
Spreadsheet 2 has A= CusPN and B= MfgPN

One CusPN represents up to 20 different MfgPN, thus when I do a Vlookup I
only get the first MfgPN from Spreadsheet 2. I need to return all results.
I am guessing I can use a table array and set up as a macro for everyday use.
Can someone help? The worksheet is 7 Columns wide total (A-G). I know how
to set this up as a macro and have tried to make this work but have had no
luck. PLEASE help! My whole spreadsheet is 30K lines long and I have been
doing this weekly manually. My eyes are bleeding... Ha Ha
Thank you,
Lisa