Forum Discussion

25 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    I will point you in the right direction!

    You just need to one of the lookup functions such as VLOOKUP.

    So, please check out this https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1!

     

    Regards,

    Haytham

    • testing out's avatar
      testing out
      Copper Contributor

      That helped, but it didn't give me the necessary directions on what I wanted to do.  It just showed me an example and the example didn't match what I was trying to accomplish.

      So I'm going to try again.  If you have to direct me to a video showing me how to do it, vs explaining it to me or showing me out right how the formula will need to work, please don't respond.  Thank you.

       

      De

      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor

        Hi,

         

        On the PDF you attached, let me understand that you're trying to do!

        You typed the last name in the cell next to Round 1 in the second sheet, and if this name is matched with the last name in the first sheet, then you want to return the Head Coach in the corresponding cell in the first sheet??

Resources