How to copy a cell if criteria matches?

Erin S
Erin S
edited 01/17/23 in Formulas and Functions


I have included screenshots below. I want to copy the rank from Pivot 1 to Sheet 1 when the Account Name matches.


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Erin S,

    If your pivot is always ordered in rank order, you can use the following formula on Sheet 1:

    =MATCH([Account Name]@row, {Pivot Range 1})

    For the {Pivot Range} when typing in the formula, press here:

    Then find your pivot sheet and pick the column matching the account:

    And then press "Insert reference" in the bottom right of the opened window.

    This should give you a result like this:

    If your pivot is not sorted by rank order, I would suggest using a VLOOKUP, but this would require changing where the columns are on your pivot in order to do it. If this is the case, let me know and I can demonstrate how to do that instead!

    Hope this helps, any questions just ask. 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!