Index Match from Column to Row

Options

Answers

  • SmartLew
    SmartLew ✭✭✭✭
    Options

    Hi Vinton,

    Your Index match is formulated incorrectly, but either way I'm not sure that will get your job done.

    In the column you have the index match in in your screenshot, which value are you trying to return? Just so I can understand your intended relationship between the two sheets.

    I'm passionate about helping you leverage the truly awesome power of smartsheet!

    https://www.fiverr.com/smartlew

  • Vinton Douglas
    Options

    Thanks for responding. I am trying to return the results from the measurable elements sheet, i.2 Fully Met, Partially Met, Not Met and N/A. The results from that identified column of the measurable element sheet should be in the same order from left to right in the row of the incoming sheet.

  • Paul H
    Paul H ✭✭✭✭✭✭
    Options

    @Vinton Douglas

    IF I am understanding what you are trying to do your formula you look like the

    =INDEX({Status}, MATCH("ME 1", {Measurable Elements}, 0))

    You would have to change the "ME 1" to ME 2" in to match each column name

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!