find the name of the cell (not the value) in another column based on the location of a value in the first column

Posted on 2014-08-21
Last Modified: 2014-09-05
Column A has the word "started" and "ended" located in some cell between A5 and A184. Once I have located the word "started" and "ended"  in column A (right now I am using the match function and have the location), I want to sum the values in column K that correspond to started and ended in column A.
Question by:CA Campbell-Pearson
    LVL 47

    Accepted Solution


    pls try



    Author Closing Comment

    by:CA Campbell-Pearson
    This was great to have. I had to tweak it for some other purposes, but it really gave me the right direction. Thank you

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    Viewers will learn the basics of formula auditing in Excel 2013.
    Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now