Return the last value or latest value for a specified product

Options

Hi,

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

Tags:

Answers

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Options

    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 ✭✭
    Options

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


    Cheers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!