| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Critera to match another spreadsheet and return single criteri
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Critera to match another spreadsheet and return single criteri
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 "klmiura" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Critera to match another spreadsheet and return single cri
=INDEX('Area_Codes_US&CANADA'!$C$1:$C$2538,MATCH(1 ,('Area_Codes_US&CANADA'!$A$1:$A$2538=C3587)*('Are a_Codes_US&CANADA'!$B$1:$B$2538=D3587),0))
with Ctrl+Shift+Enter "Teethless mama" wrote: 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 "klmiura" wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup/match 2 critera | Excel Discussion (Misc queries) | |||
| VLookup a given critera and return a value without duplication | Excel Discussion (Misc queries) | |||
| Formula to return a value if any numbers in a group meet a criteri | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Hybrid Mode
