How do I use two fields to determine lookup value?

I'm sure it is possible to solve this with an array, despite all my efforts having produced nothing so far.

Attached is an example workbook. On the 'Data' sheet, every month the data will change and I need to fill in column A, with the approriate Name from the 'Map' sheet.

Is this possible using an array?

Thanking you in advance

Try:

=INDEX(Map!$C$2:$C$8,MATCH(1,(Map!$A$2:$A$8=B6)*(Map!$B$2:$B$8=C6),0))

change ranges to suit and confirm with CTRL+SHIFT+ENTER

You could use LOOKUP rather than an Array, eg:

A6:
=LOOKUP(2,1/((Map!$A$2:$A$8=$B6)*(Map!$B$2:$B$8=$C6)),Map!$C$2:$C$8)

Where the combination does not exist you will get an error - given you are seemingly always returning a text string you can handle this without resorting to double evaluation using:

A6:
=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/((Map!$A$2:$A$8=$B6)*(Map!$B$2:$B$8=$C6)),Map!$C$2:$C$8)))

(change the Null to whatever you want to appear where error occurred trying to locate the combination)