Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

MATCH Formula

Options
Stephanie Taylor
Stephanie Taylor ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

OK I'm loving these new formulas but I need help with the MATCH formula.  I have column A with serial numbers in it.  I want to scan serial numbers into column B and use the MATCH formula to match it to column A.  How would you write the formula?

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    MATCH returns an number, not the actual value.

    To do that, you need to add it to INDEX.

     

     

    I'm not sure what you expect to get from the two columns.

    Can you post a screen shot?

     

    Craig

     

     

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Stephanie's problem has been resolved.

     

    She was looking to use the MATCH function to find the position in the column and then translate that into the row number. She wasn't looking to retrieve any other information (which would require using the INDEX function)

     

    So we just added the table's offset to the number returned by the MATCH function and Bob's your uncle.

     

    Craig

This discussion has been closed.