I've got a table with a gross amount of information in it. Each row in the table represents a different date and shift. I am wanting to make a quick shot look of all the important information and pull information from the table if it matches the shift and date on the overview sheet. I know this isn't the best explanation but I have attached a simplified example. The small box under the table would be on a serperate page (the overview page) but this gives you the idea I am shooting for. I have worn myself out trying diffent ways to get it to populate, and tried to learn the vlookup and hlookup functions but they are just confusing me more than helping. Any help is greatly appreciated.
Bookmarks