Using INDEX(COLLECT()) or VLOOKUP
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
Check out the Formula Handbook template!