Double Index and Match?? Formula Help!

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

Thanks for your quick reply. I mocked up a document but I am not able to attach it, no drop down occurs when clicking, tried three different devices and two browsers!

Not sure what the issue us, my profile allows me to attach files but the attach button does not work - any ideas how else to provide the document?

Thanks,

Chris

To Attach a File:

1.Click "Go Advanced"
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.