How do I use two fields to determine lookup value?

[Militia]

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

[NBVC]

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

[DonkeyOte]

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)

[Militia]

Thank you both very much for your help.

Both worked just as I needed!

-Militia

[amartino44]

Could you please explain this with more detail. I've read about array formulas but they are not my friend. Thanks.