Two Critera to match another spreadsheet and return single criteri

[klmiura]

I have one workbook with two spreadsheets:

Spreadsheet 1 name: 5-digit_Consolidted
Spreadsheet 2 name: Area_Codes_US&CANADA

I am trying to match the criteria from Spreadsheet 1 cell C1 and cell D1 to
Spreadsheet 2 cells A1 and cell B1 and return the matching value in column C1
from Spreadsheet 2. (I am looking up and matching city and state to return
area code from the lists)

Here is the current formula I have and I have it set as an array:

{=INDEX(MATCH(C3587,'Area_Codes_US&CANADA'!$A$1:$C$2538),MATCH(D3587,'Area_Codes_US&CANADA'!$A$1:$C$2538,3))}

Please help!!

 

[Teethless mama]

INDEX('Area_Codes_US&CANADA'!$A$1:$C$2538,MATCH(1,('Area_Codes_US&CANADA'!$A$1:$C$2538=C3587)*('Area_Codes_US&CANADA'!$A$1:$C$2538=D3587),0))

ctrl+shift+enter, not just enter

 

[Toppers]

=INDEX('Area_Codes_US&CANADA'!$C$1:$C$2538,MATCH(1,('Area_Codes_US&CANADA'!$A$1:$A$2538=C3587)*('Area_Codes_US&CANADA'!$B$1:$B$2538=D3587),0))

with Ctrl+Shift+Enter