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?

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.

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.

    =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

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.

    =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

  • ✭✭✭

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions