Match Formula

Samuel Dowdy Jr.
Samuel Dowdy Jr. ✭✭✭✭✭✭
in Formulas and Functions

Im trying to match a cell if my two project names match. How?


=IF({Profit Center} = [Profit Center]@row, {Division})

· Share on FacebookShare on Twitter

Best Answer

  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Hey @Samuel Dowdy Jr.

    To clarify, are you trying to find the Division name that corresponds to matching Profit Center names?

    If that is your question, this formula should help. If this isn't the question, please clarify.

    =Index({Division}, MATCH([Profit Center]@row, {Profit Center}, 0))

    Please let us know if this isn't what you're looking for

    · Share on FacebookShare on Twitter

Answers

  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Hey @Samuel Dowdy Jr.

    To clarify, are you trying to find the Division name that corresponds to matching Profit Center names?

    If that is your question, this formula should help. If this isn't the question, please clarify.

    =Index({Division}, MATCH([Profit Center]@row, {Profit Center}, 0))

    Please let us know if this isn't what you're looking for

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!