Lookup based on Two Variables in Multiple Worksheets

Hi all,

Please could someone assist me, as I'm struggling with the following? thanks!

- I have 3 tabs: Combined, Type 1 and Type 2
- Each tab includes data based on 3 columns: Region, Identification number and Service Start/Change Date

I would like the 'Combined' tab to display the correct 'Service Start/Change Date' based on the 'Region' and 'Identification Number' from both 'Type 1' and 'Type 2' tabs, respectively.

I've tried using VLOOKUP but having looked on-line I think INDEX & MATCH or INDIRECT is a better option, unless I'm mistaken?

I've attached the spreadsheet. Any feedback is greatly appreciated!

Regards
jusmightmightbeokay