Lisa
You need to provide more detail about the layout of what you have and
the layout of what you want to happen. You say sheet 1 has A=CusPN. Is
this column A? And is "CusPN" the header for column A?
You say sheet 2 has the CusPN (column header?) and B (column B?) has MfgPN
and that MfgPNs are about 20 to 1.
You say that you want to return all the MfgPN for one CusPN. Where do you
want this?
If I have guessed right about what you want, it's simple to do with a macro.
Post back with more layout detail. HTH Otto
"lmarquis" <u23027@uwe wrote in message news:61c696989b89f@uwe...
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