Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Index Look Up - Help a Newbie?

    ✭✭✭
    in Formulas and Functions

    Hi trying to write a very basic INDEX/MATCH formula to look up the ballpark name and ballpark address from ST Addresses and insert into Arizona Schedule. My formula is saying "no match". What am I doing wrong?!

    This is my formula below

    =INDEX({ballpark name}, MATCH(Team@row, {Ballpark}, 0))

    – writing the formula here to have the team name and address pop up in yellow cells.

    image.png
    image.png
    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      Hi BrookeDawn,

      I'm assuming you are using the 'reference another sheet' link in your formula? I don't see the reference names in the formula you copied in. This is what one of my formulas looks like where I am pulling the clinic name in based on the address.

      image.png

      =INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)

      Hope this helps.

      Brooke

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      Hi BrookeDawn,

      I'm assuming you are using the 'reference another sheet' link in your formula? I don't see the reference names in the formula you copied in. This is what one of my formulas looks like where I am pulling the clinic name in based on the address.

      image.png

      =INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)

      Hope this helps.

      Brooke

      · Share on FacebookShare on Twitter
    • ✭✭✭

      that worked - i really appreciate you taking the time to answer this!

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions