Return the last value or latest value for a specified product

Emad AJ

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

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

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

Cheers