I've attached the second spreadsheet for better understanding.
I am trying to develop a formula that will compare the a unit number from one table (or range of cells) and highlight the correct times for that specific unit on another set of cells. I'm not sure if it should be a VLOOKUP, IF Statement, or what. I'm doing appointment scheduling, so it needs to compare the unit and its times and highlight the cells accordingly for each specific unit.
Bookmarks