Return the last value or latest value for a specified product



I am trying to return the most recent value for any part description

Vlookup always gets the first one, any idea on how to 99 from the example below without sorting the data .. as the rows will be added automatically to this sheet from another sheet and they always go to the bottom row

Thank you



  • markkrebs
    markkrebs ✭✭✭✭✭✭

    Never use vlookup.... Index(match()) instead. Vlookup gets jacked if you or someone else rearranged a column. Add the standard #auto number column and then you can use the max function to get the last row. This will only work if, as you indicate above, the new data always goes to the bottom. If this weren't the case you'd need some other helper columns.

  • Emad AJ
    Emad AJ ✭✭

    @markkrebs Thank you, used INDEX MATCH with COLLECT and MAX functions and worked perfectly


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!