VLOOKUP based on cell id or keywords?


I'm trying to see if there's a better way to do something. I'm trying to pull an Employee status based on the staff "calendar" (It's not a calendar - it's a grid sheet). Right now, I'm using a VLOOKUP to extract each employee's status for the day. However, my main concern with the VLOOKUP, is that is calls on column #, which will become a problem if there's a new employee added, and the order changes. Is there a way to reference the column unique id, or maybe even a different formula to use? I'm open to any suggestions! I tried doing a Join & collect, but am having trouble adding a second criteria to look for the date and then the employee name.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!