Forum Discussion

testing out's avatar
testing out
Copper Contributor
Oct 24, 2018
Solved

Excel formula help

Hi all, I'm trying to create an excel formula and don't know how to start.  I know what I want it to do, but don't know how to make it work.  Please see the attached PDF.  Thanks!   Dean  
excel
Formulas and Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 24, 2018

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
    Oct 31, 2018

    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
      Nov 01, 2018

      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??

      • testing out's avatar
        testing out
        Copper Contributor
        Nov 01, 2018

        Yes, that is correct.  Anytime I put a name in the round, it should automatically associate the coach name and then put the head coach name in the other page.  Can you do that?  Thanks!

        Dean

Resources