Lookup & Match?
Posted by Jennifer Ann on March 09, 2001 7:02 AM
On sheet 1, column A lists over 200 company names, column B the commodity of each company. I need a formula that, when I enter (paste, actually) a company name on sheet 2, column A, will look for that company name on sheet 1, and if it finds a match, enter the oppropriate commodity from sheet 1, column B into sheet 2, column B. A report will generate a list of over 400 company names that I can copy and paste into sheet 2, and at this point I still have to manually search for each company name and enter any matching commodity listing. Those without matching commodities are moved to another sheet.
Thanks for any help!