Thank you for your help. An example of "partial match" might be:

In worksheet1, the company  name might be listed as "Microsoft Corp" in
one row, then as "Microsoft Corporation" in another row, and perhaps
"Microsoft (Windows CE)" in another row...while the company name in
worksheet2, would simply be "Microsoft."

But in thinking about it further, maybe it would just be easier to
look for exact matches, and just have a longer list in worksheet2,
that would include all the variations of a particular company
name...even though it's redundant, but otherwise not adverse.??

Any suggestions/examples for a procedure using vLookup would be
greatly appreciated. I've seen some on MSDN of course, but your
thoughts are important & appreciated.