function to compare certain cells between two sheets

So I have 2 excel sheets. I need to match data from Sheet 1 in column C to data in Sheet 2 in Column B. They are not in order. I am looking for axact names within the 6000 cells.

If there is a match I want to pull the corresponding data from Sheet 1 column G.

The names that I am trying to match are product names so some are about 6 words long.

How can I do this??? HELP!!!!

 

PS. I am on a MAC so I cannot seem to use any ad ons.

By: Katrina

Leave a Reply

Your email address will not be published. Required fields are marked *