| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching multiples fields in 1 row
Hi, I have data listed in rows, with columns A:E making up the unique
identifiers. I want to match the 5 fields and return the data in the next column. I could write a formula matching the 5 fields like this =INDEX(F:F, MATCH(A2&B2&C2&D2&E2,A1:A500&B1:B500&C1:C500&D1:D5 00&E1:E500, FALSE)) but it's kind of long. Is there anyway to specify the range A:E, instead of explicitly writing everything out? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Linear Mode
