Excel formula matching sheet1 and sheet2 and getting result












0















Can someone please help on Excel formula:
I have a spredsheet With two sheets.




  1. In sheet1 I have two column

  2. In sheet2 I have tree column.

  3. I want two column from sheet1 to match With two column in sheet2.

  4. When match get result from the column 3 in sheet2 into an cell in sheet1.










share|improve this question

























  • superuser.com/questions/1248964/…

    – Eric F
    Jan 15 at 15:24
















0















Can someone please help on Excel formula:
I have a spredsheet With two sheets.




  1. In sheet1 I have two column

  2. In sheet2 I have tree column.

  3. I want two column from sheet1 to match With two column in sheet2.

  4. When match get result from the column 3 in sheet2 into an cell in sheet1.










share|improve this question

























  • superuser.com/questions/1248964/…

    – Eric F
    Jan 15 at 15:24














0












0








0








Can someone please help on Excel formula:
I have a spredsheet With two sheets.




  1. In sheet1 I have two column

  2. In sheet2 I have tree column.

  3. I want two column from sheet1 to match With two column in sheet2.

  4. When match get result from the column 3 in sheet2 into an cell in sheet1.










share|improve this question
















Can someone please help on Excel formula:
I have a spredsheet With two sheets.




  1. In sheet1 I have two column

  2. In sheet2 I have tree column.

  3. I want two column from sheet1 to match With two column in sheet2.

  4. When match get result from the column 3 in sheet2 into an cell in sheet1.







microsoft-excel worksheet-function






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 15 at 15:20









Eric F

2,79031331




2,79031331










asked Jan 15 at 15:17









perper

1




1













  • superuser.com/questions/1248964/…

    – Eric F
    Jan 15 at 15:24



















  • superuser.com/questions/1248964/…

    – Eric F
    Jan 15 at 15:24

















superuser.com/questions/1248964/…

– Eric F
Jan 15 at 15:24





superuser.com/questions/1248964/…

– Eric F
Jan 15 at 15:24










1 Answer
1






active

oldest

votes


















0














Try this formula and check if this will help you:



=LOOKUP(1,0/((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),Sheet2!C:C)


enter image description here



enter image description here






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1394564%2fexcel-formula-matching-sheet1-and-sheet2-and-getting-result%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Try this formula and check if this will help you:



    =LOOKUP(1,0/((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),Sheet2!C:C)


    enter image description here



    enter image description here






    share|improve this answer




























      0














      Try this formula and check if this will help you:



      =LOOKUP(1,0/((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),Sheet2!C:C)


      enter image description here



      enter image description here






      share|improve this answer


























        0












        0








        0







        Try this formula and check if this will help you:



        =LOOKUP(1,0/((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),Sheet2!C:C)


        enter image description here



        enter image description here






        share|improve this answer













        Try this formula and check if this will help you:



        =LOOKUP(1,0/((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),Sheet2!C:C)


        enter image description here



        enter image description here







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 16 at 1:15









        LeeLee

        89927




        89927






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1394564%2fexcel-formula-matching-sheet1-and-sheet2-and-getting-result%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Plaza Victoria

            In PowerPoint, is there a keyboard shortcut for bulleted / numbered list?

            How to put 3 figures in Latex with 2 figures side by side and 1 below these side by side images but in...