How to select next greatest Date based on customer match in EXCEL?Moving to the next line of data when the...

Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?

What makes papers publishable in top-tier journals?

Sharepoint metadata URL

Boss asked me to sign a resignation paper without a date on it along with my new contract

Can you determine if focus is sharp without diopter adjustment if your sight is imperfect?

Is there a verb that means to inject with poison?

The No-Straight Maze

Are the positive and negative planes inner or outer planes in the Great Wheel cosmology model?

How vim overwrites readonly mode?

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Charging phone battery with a lower voltage, coming from a bike charger?

How do I avoid the "chosen hero" feeling?

How to write cases in LaTeX?

Website seeing my Facebook data?

Stuck on a Geometry Puzzle

What natural barriers could help when running away from a lightning elemental?

Reading Mishnayos without understanding

How to politely refuse in-office gym instructor for steroids and protein

Need help with a circuit diagram where the motor does not seem to have any connection to ground. Error with diagram? Or am i missing something?

Does the ditching switch allow an A320 to float indefinitely?

Does diversity provide anything that meritocracy does not?

Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?

Non-Cancer terminal illness that can affect young (age 10-13) girls?

How do you get out of your own psychology to write characters?



How to select next greatest Date based on customer match in EXCEL?


Moving to the next line of data when the date changesHow to check if a date is within a given range in Microsoft excelExcel Formula for Sum of hours based on date selectedExcel formula to calculate sums of a row across more than 1 tab (different names), based on dateExcel 2013 - select a date range and filted by agentexcel, find last previous dateCalculate the number of days per year between two different dates ExcelExcel - Date detection/comparison in mixed format cellsCalculate date when age plus service equals specific value in ExcelFormula based around dates













0















I need a formula to pull in the next greatest date based on customer match from a another set of data.



So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab










share|improve this question







New contributor




Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I need a formula to pull in the next greatest date based on customer match from a another set of data.



    So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab










    share|improve this question







    New contributor




    Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I need a formula to pull in the next greatest date based on customer match from a another set of data.



      So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab










      share|improve this question







      New contributor




      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I need a formula to pull in the next greatest date based on customer match from a another set of data.



      So on one tab I have Customer JOE who has a service date of 1/1/19. On another tab is all service dates JOE had ranging from Dec 2018-Feb 2019. I need to pull in the next service date after the 1/1/19 from the original tab







      microsoft-excel






      share|improve this question







      New contributor




      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 5 hours ago









      JillianJillian

      1




      1




      New contributor




      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Jillian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          1 Answer
          1






          active

          oldest

          votes


















          0














          Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:



          =INDEX(dates,MATCH(A1,dates,0)+1)


          Just adjust the ranges as needed



          enter image description here



          (Note: I have dates as a named range, column D (and this goes all the way to 2/28/2019)






          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
            });


            }
            });






            Jillian is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1409248%2fhow-to-select-next-greatest-date-based-on-customer-match-in-excel%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














            Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:



            =INDEX(dates,MATCH(A1,dates,0)+1)


            Just adjust the ranges as needed



            enter image description here



            (Note: I have dates as a named range, column D (and this goes all the way to 2/28/2019)






            share|improve this answer




























              0














              Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:



              =INDEX(dates,MATCH(A1,dates,0)+1)


              Just adjust the ranges as needed



              enter image description here



              (Note: I have dates as a named range, column D (and this goes all the way to 2/28/2019)






              share|improve this answer


























                0












                0








                0







                Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:



                =INDEX(dates,MATCH(A1,dates,0)+1)


                Just adjust the ranges as needed



                enter image description here



                (Note: I have dates as a named range, column D (and this goes all the way to 2/28/2019)






                share|improve this answer













                Assuming your dates in Sheet2 are contiguous without any blanks, you can use this:



                =INDEX(dates,MATCH(A1,dates,0)+1)


                Just adjust the ranges as needed



                enter image description here



                (Note: I have dates as a named range, column D (and this goes all the way to 2/28/2019)







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 2 hours ago









                BruceWayneBruceWayne

                1,8771721




                1,8771721






















                    Jillian is a new contributor. Be nice, and check out our Code of Conduct.










                    draft saved

                    draft discarded


















                    Jillian is a new contributor. Be nice, and check out our Code of Conduct.













                    Jillian is a new contributor. Be nice, and check out our Code of Conduct.












                    Jillian is a new contributor. Be nice, and check out our Code of Conduct.
















                    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%2f1409248%2fhow-to-select-next-greatest-date-based-on-customer-match-in-excel%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

                    Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

                    VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

                    Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...