I am compiling responses from 28 vendors to collect information regarding the country of origin of each part. I tried to use If and Vlookup statements but I have more than the limit so I think I will need to write a macro to match the vendor numbers in sheet 1 with the vendor numbers in the other sheets then, if it matches, do a vlookup on that specific row. As I just started trying to learn VBA, I could use some assistance. Can you all help me out?