Formula needed



I am trying to establish a formula to reference certain cells between two tables as the below.






In Sheet1

Return the type of meal in column C by matching the name and fruit type from Sheet1 to Sheet2. Values should return as follow. Please note, the data I am working on is more than 2 rows and therefore I need a formula that would be valid when applied to multiple rows not just 2.

Thank you!

By: Alaya

19 thoughts on “Formula needed

  1. ig

    I think this is one of the so much significant info for me.
    And i am happy studying your article. But should remark on few normal issues, The
    website taste is ideal, the articles is really excellent :
    D. Excellent activity, cheers

  2. sling tv

    What’s up everyone, it’s my first go to see at this site, and
    post is actually fruitful in favor of me, keep up posting these posts.

  3. sling tv

    Hello there! Do you know if they make any plugins
    to help with Search Engine Optimization? I’m trying to
    get my blog to rank for some targeted keywords but I’m not seeing
    very good results. If you know of any please share.

    Appreciate it!


    Just desire to say your article is as astounding. The clearness
    for your publish is just cool and that i can think you are a professional in this subject.
    Well with your permission allow me to grab your feed to stay updated with approaching post.
    Thanks a million and please continue the rewarding work.

  5. coconut oil

    I’m really enjoying the theme/design of your website.
    Do you ever run into any browser compatibility problems?
    A number of my blog audience have complained about my blog not working correctly in Explorer
    but looks great in Chrome. Do you have any tips to help fix this issue?

  6. ps4 games

    Howdy! I just would like to give you a huge thumbs up for the excellent info you have right here on this post.

    I’ll be returning to your web site for more soon.

  7. ps4 games

    Hey there! I know this is kinda off topic however I’d figured
    I’d ask. Would you be interested in exchanging links or maybe
    guest authoring a blog post or vice-versa? My blog addresses a lot of the same subjects as yours and I think
    we could greatly benefit from each other. If you happen to be interested feel free
    to send me an e-mail. I look forward to hearing from
    you! Terrific blog by the way!

Comments are closed.