Index/Match trouble with returning text value

My goal here is retrieve the Row 1 values(grey cell color) based on where the match cell (value = 14) in this case falls under. I added a row identical to the column header values to try to get this method to work but if there is a way to retrieve the column header for the top 3 highest values in a row please let know. Thanks.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The problem is the location of your MATCH. Your MATCH function is in the place that determines the row to pull from in the INDEX function. Replace that with 1 and move the MATCH to the 3rd portion of the INDEX function that specifies which column to pull from.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!