Hi all,

I have been unable to solve this particular problem for a while now, it seems to have defeated me!

I need Excel to; Match Cell: 'Directorate' AND Cell: 'Week Commencing' in Tab A, Look for 'Directorate' AND Cell: 'Week Commencing' in Tab B (where the master data is held) and return me the value from that dataset.

I am struggling to say the least - I hope the above is clear or somebody can interpret my lack of knowledge in this area

Many thanks,


Chris