Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    INDEX & MATCH not providing expected OUTPUT

    ✭✭✭
    edited 07/22/24 in Formulas and Functions

    Good Evening,

    The sheet I am working has Unique IDs inputted by the users, however, the Section/Chapter Name for each Unique ID is generate on a different sheet called the Chapter/Section Awardee Notification, scroll to the bottom

    I would like to reference the Section/Chapters Names and align them with their respective Unique IDs on my current sheet I am working on below, see first image. I have attempted a few variations of the current formula but the output I get is shown below in the Section/Chapter Name Column in the first image.

    =INDEX({Chapter/Section Awardee Notification}, MATCH([Record your Chapter/Section/Club Unique ID]@row, {Chapter/Section Awardee Notification Range 1}))

    Formula Translation =INDEX({Chapter/Section Awardee Notification pull Section/Chapter Name}, MATCH([Record your Chapter/Section/Club Unique ID with inputted Unique ID]@row, {Chapter/Section Awardee Notification Range 1 pull Quarter - Chapter/Section/Club Unique ID}))

    Current Sheet I am working on:

    image.png

    Chapter/Section Awardee Notification reference for each Unique ID their is a specific Section/Chapter Name

    image.png

    Thanks for your thoughts on this

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • Community Champion
      Answer ✓

      Hey @NCNWIncData

      Before trying any other modifications to your formula, please try adding the Search_type to your formula. Personally, I consider this a mandatory field even though it is written as optional.

      =INDEX({Chapter/Section Awardee Notification}, MATCH([Record your Chapter/Section/Club Unique ID]@row, {Chapter/Section Awardee Notification Range 1},0))

      Does this solve your issue?
      Kelly

      · Share on FacebookShare on Twitter

    Answers

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions