how to handle duplicate data from the source sheet when using vlookup?


I have a work schedule sheet (source/reference data) and shift schedule of employees is being logged there. Employees shift schedule can be night shift and day shift per employee. Now, I have another sheet (Control log sheet) where I am looking up the work schedule of each employee in a daily basis. When I am using the normal look up it only returns me the first shift scheduled logged (ex. nigh shift). I want the newest schedule to loook up.

May I know what modification with the normal vlookup formula so that it returns the newest or recent shift schedule?

Or Do we have other formula we can use for this? (I have searched the threads but I have read about using =join(collect( , but the problem is I don't how it works.)

Kindly help me to solve this. thank you.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!