I have a data base that has part numbers listed multiple times based on production date. I am trying to gather the status (RED, GREEN, YELLOW) symbol from another column but I want to make sure it is from the most recent addition to the data base. New data is added via form to the top of the DB.

I believe VLOOKUP will return the value at the top of the sheet but I really like using INDEX(COLLECT()) to locate the info incase the column order ever changes but I don't know how to ensure it is the most recent data since the criterion (Part #) is listed multiple times.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!