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

9 thoughts on “function to compare certain cells between two sheets

  1. yeezy shoes

    Oh my goodness! an incredible article dude. Thanks However I’m experiencing difficulty with ur rss . Don抰 know why Unable to subscribe to it. Is there anybody getting equivalent rss drawback? Anybody who knows kindly respond. Thnkx

  2. calvin klein outlet

    Aw, this was a very nice post. In thought I wish to put in writing like this moreover ?taking time and precise effort to make a very good article?however what can I say?I procrastinate alot and by no means seem to get one thing done.

  3. air jordan

    That is the fitting blog for anyone who needs to find out about this topic. You realize a lot its virtually exhausting to argue with you (not that I really would want匟aHa). You positively put a new spin on a topic thats been written about for years. Great stuff, simply great!

  4. http://tinyurl.com

    I absolutely love your blog.. Pleasant colors & theme. Did you develop this site yourself?
    Please reply back as I’m trying to create my own personal site and want to know where you got this from or what the theme is named.
    Thanks!

  5. for coconut oil

    Good day I am so glad I found your site, I
    really found you by mistake, while I was researching on Digg
    for something else, Nonetheless I am here now and would just like to say many thanks
    for a tremendous post and a all round exciting blog (I also love the theme/design),
    I don’t have time to go through it all at the moment but I have book-marked it and also
    added your RSS feeds, so when I have time I will be back to read more,
    Please do keep up the superb work.

  6. plenty of fish dating site

    Hey There. I discovered your blog the usage of msn. That is a
    very neatly written article. I’ll make sure to bookmark it and return to learn extra of your helpful
    info. Thanks for the post. I’ll definitely return.

  7. kyrie 6

    I discovered your weblog website on google and examine just a few of your early posts. Continue to maintain up the excellent operate. I just additional up your RSS feed to my MSN Information Reader. Searching for ahead to studying extra from you in a while!?

  8. adidas nmd

    I used to be more than happy to seek out this internet-site.I needed to thanks on your time for this excellent read!! I undoubtedly enjoying every little bit of it and I have you bookmarked to take a look at new stuff you blog post.

  9. jordan shoes

    Good post. I study something more difficult on different blogs everyday. It should at all times be stimulating to learn content from different writers and apply just a little something from their store. I抎 desire to make use of some with the content material on my weblog whether or not you don抰 mind. Natually I抣l offer you a hyperlink in your net blog. Thanks for sharing.

Leave a Reply

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