Sheet 1 is a d/l of info, has company#....sheet 2 has two columns, company# and company name...I want to be able to reference sheet 2 from sheet 1 in a new company name column, and have the company name automatically be put in based on the company#...how do I do this?
Thanks
Thanks