Hi,

Tough to explain so I have attached a sample sheet for you to play. Your help and advice is appreciated... DOING MY HEAD IN!

I have a table with data in it. I also have a timetable (separate to data table). I need the timetable to LOOKUP the data table for TWO criteria and, if it finds a match, return a THIRD result in the cell on the timetable that corresponds to the first two criteria. Simple, right!

So, we have Client, State and Date in the data table. I need the timetable to insert the client name in the appropriate state column on the corresponding date row.

Probably easier to see example. If you need clarification, let me know!

Test_tracker_example.xlsx