Lookup Value based on 3 criteria

Hi,


I am currently building a summary sheet where the data will be obtain from master spreadsheet. The problem I am facing is it requires me to use 3 lookup criteria.

If you look at sheet 1, in order to populate value from cell B4 to D11, there are 3 criterias to be satisfied.
first one is the month, cell A1, second is Sector, A4 to A11 and lastly the date, B3 to D4.

i manage to use Hlookup Match, but i am unable to use OFFSET on top of that formula.

Formula:

=HLOOKUP($A$1,'[Busget 15-16.xlsx]Master Data'!$BL$2:$DA$121,MATCH('[Busget 15-16.xlsx]Summary'!A4,'[Busget 15-16.xlsx]Master Data'!$A$2:$A$121,0),FALSE)

I have attached the sample spreadsheet and any help would be gladly appreciated.

Thanks
Lex