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

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

  1. air jordan shoes

    I happen to be writing to make you know of the wonderful discovery my princess obtained visiting yuor web blog. She figured out numerous issues, including what it is like to have an incredible coaching spirit to let men and women with ease master various complex things. You really did more than her expected results. Thanks for offering the good, dependable, edifying and in addition fun thoughts on your topic to Janet.

  2. yeezys

    I enjoy you because of each of your effort on this web site. Betty enjoys conducting research and it’s easy to see why. I know all about the dynamic method you create effective tricks through this web site and therefore boost response from other people about this point and our favorite girl is undoubtedly understanding a whole lot. Enjoy the rest of the new year. Your conducting a fantastic job.

  3. Kandis

    Hello! Do you use Twitter? I’d like to follow you if that would be ok.
    I’m definitely enjoying your blog and look forward to new posts.

  4. curry 6 shoes

    I and also my pals were found to be viewing the best thoughts found on your web site and unexpectedly got a terrible feeling I had not thanked you for them. The people happened to be stimulated to learn all of them and now have seriously been loving them. Appreciation for genuinely simply accommodating and then for obtaining some very good information most people are really needing to be aware of. Our own honest apologies for not expressing appreciation to you sooner.

  5. nike air max

    I intended to create you the bit of observation to give thanks as before with the striking secrets you’ve documented in this article. It has been simply unbelievably generous of people like you giving unreservedly precisely what most people could possibly have offered for an e-book to help make some bucks on their own, certainly considering the fact that you could possibly have done it if you wanted. These smart ideas in addition worked like the easy way to recognize that someone else have the same dreams like my own to learn more with regards to this matter. I believe there are numerous more fun occasions ahead for those who looked at your blog.

  6. supreme clothing

    I would like to voice my admiration for your kindness in support of those people who really need guidance on this study. Your real commitment to passing the solution all-around became particularly invaluable and have regularly allowed girls just like me to realize their aims. Your personal helpful key points signifies a whole lot to me and even more to my office workers. Warm regards; from everyone of us.

  7. louboutin shoes

    I wanted to write a remark to be able to thank you for all the amazing secrets you are posting here. My time intensive internet investigation has at the end been paid with reliable ideas to exchange with my guests. I would admit that most of us readers are unquestionably fortunate to dwell in a magnificent site with many special people with insightful pointers. I feel somewhat happy to have discovered the web pages and look forward to tons of more cool moments reading here. Thanks a lot again for everything.

  8. sling tv

    I’m gone to inform my little brother, that he should also go to see this webpage
    on regular basis to get updated from most up-to-date

  9. lebron 14

    I not to mention my pals were found to be looking through the best key points located on the website and the sudden developed a terrible suspicion I had not expressed respect to you for those secrets. Most of the women had been as a consequence stimulated to read through all of them and now have extremely been enjoying these things. I appreciate you for simply being really kind and for utilizing some essential subject areas most people are really desperate to learn about. My honest apologies for not expressing gratitude to you sooner.

  10. golden goose

    Needed to compose you one little bit of note in order to say thank you as before over the stunning ideas you have contributed on this page. It’s certainly remarkably open-handed of you to grant openly exactly what a number of us could have offered for sale as an electronic book to generate some profit for their own end, principally given that you might have done it in case you desired. Those advice likewise worked like the great way to realize that most people have the identical fervor like my very own to figure out good deal more in regard to this condition. I am sure there are lots of more pleasurable sessions up front for many who scan through your website.

  11. hermes handbags

    I enjoy you because of all your valuable work on this website. Kim really likes going through internet research and it’s simple to grasp why. Many of us hear all concerning the lively method you produce advantageous tactics on your web site and in addition welcome participation from some other people on this topic plus our daughter has been studying a lot of things. Take advantage of the rest of the new year. You are conducting a superb job.

  12. sling tv

    Hey There. I found your blog using msn. This is a really well
    written article. I will be sure to bookmark it and return to read
    more of your useful information. Thanks for the post. I will definitely comeback.

  13. balenciaga

    I would like to show my appreciation to the writer just for rescuing me from this type of problem. Right after checking throughout the world wide web and getting concepts which are not helpful, I figured my life was well over. Living without the solutions to the issues you have sorted out all through your main site is a serious case, and those which may have badly affected my career if I had not encountered the website. Your own personal ability and kindness in handling a lot of stuff was crucial. I am not sure what I would have done if I hadn’t discovered such a subject like this. I’m able to at this moment relish my future. Thank you so much for the professional and result oriented guide. I will not be reluctant to refer the website to anyone who would like assistance about this area.

  14. air jordans

    I needed to put you the very little note to be able to give many thanks once again with your pretty techniques you have discussed on this site. It is seriously generous of people like you to offer unreservedly just what many people could have advertised for an e-book to end up making some dough on their own, mostly seeing that you could possibly have done it if you ever decided. Those points as well acted to be the good way to be certain that other people have similar dreams the same as my very own to figure out a good deal more pertaining to this condition. I am certain there are thousands of more fun times ahead for individuals who read your website.

  15. sling tv

    I was suggested this website by my cousin. I am not
    sure whether this post is written by him as no one else know such detailed about my problem.
    You’re incredible! Thanks!

  16. hermes birkin

    I wish to show thanks to this writer just for bailing me out of such a challenge. Because of looking throughout the the net and finding solutions which are not productive, I was thinking my entire life was gone. Existing minus the strategies to the problems you’ve sorted out through your entire short article is a serious case, and the ones which could have badly damaged my career if I hadn’t noticed the blog. Your personal knowledge and kindness in handling all areas was priceless. I am not sure what I would have done if I hadn’t discovered such a subject like this. I can also now look ahead to my future. Thanks so much for this expert and result oriented guide. I won’t hesitate to suggest your blog to any individual who requires tips on this subject.

  17. michael kors factory outlet

    I would like to convey my respect for your generosity for persons that absolutely need assistance with this matter. Your special dedication to getting the solution all over appears to be particularly beneficial and has in every case enabled employees much like me to achieve their pursuits. Your new invaluable instruction can mean a whole lot to me and much more to my office workers. Thank you; from everyone of us.

  18. sling tv

    This is very interesting, You are an excessively skilled
    blogger. I’ve joined your feed and look forward to searching
    for more of your excellent post. Additionally, I’ve
    shared your website in my social networks

  19. free trial

    I know this if off topic but I’m looking into starting my
    own weblog and was wondering what all is required to get setup?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very web savvy so I’m not 100% certain. Any suggestions or advice would
    be greatly appreciated. Many thanks

  20. supreme clothing

    My spouse and i were absolutely lucky when Emmanuel managed to round up his reports through the ideas he had using your weblog. It is now and again perplexing just to choose to be giving for free instructions which often other folks could have been selling. Therefore we keep in mind we now have the website owner to thank for this. The main explanations you have made, the straightforward blog menu, the relationships you will make it possible to engender – it’s got most extraordinary, and it’s really aiding our son and us reason why the matter is fun, which is certainly pretty pressing. Thank you for the whole thing!

  21. supreme shirt

    I and my friends came digesting the excellent information and facts on your site and then before long I had an awful suspicion I never thanked the web site owner for those tips. All of the young boys had been totally very interested to learn all of them and have seriously been using those things. Appreciation for genuinely very helpful as well as for pick out varieties of beneficial areas most people are really needing to know about. My very own sincere regret for not saying thanks to you sooner.

  22. supreme hoodie

    I really wanted to jot down a simple message to be able to thank you for those lovely advice you are giving out on this site. My time intensive internet search has at the end of the day been compensated with extremely good facts and techniques to talk about with my co-workers. I ‘d suppose that we readers actually are extremely blessed to exist in a good place with so many lovely people with interesting opinions. I feel pretty lucky to have used your entire web site and look forward to so many more thrilling moments reading here. Thanks again for all the details.

  23. canada goose

    I actually wanted to write down a small comment to be able to thank you for those splendid advice you are posting on this site. My extensive internet look up has at the end of the day been honored with beneficial facts to exchange with my visitors. I would believe that we site visitors are undeniably fortunate to be in a fabulous network with so many outstanding people with useful techniques. I feel truly lucky to have seen your website page and look forward to many more amazing moments reading here. Thank you once again for a lot of things.

  24. ps4 games

    Very nice post. I just stumbled upon your weblog and wished to say that I’ve really
    enjoyed surfing around your blog posts. In any case I’ll be subscribing to your rss feed
    and I hope you write again soon!

  25. Sana Duk

    I?d have to check with you here. Which is not something I usually do! I enjoy reading a post that will make people think. Also, thanks for allowing me to comment!

  26. 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.

  27. 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.

  28. 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!?

  29. 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.

  30. 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.


    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.

  32. 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!

  33. 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.

  34. 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

Comments are closed.