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.