| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: reading tables with multiple rows and columns
Tried Vlookup, Hlookup, =if, Index, etc., but would need 37x37 variables per
line of formulae. Macro would also be too long. Friend of mine suggested Visual Foxpro. Any chance of an Excel solution? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel: reading tables with multiple rows and columns
R.A.,
=INDEX(TableArray,MATCH(RowLabelToFind,RowLabels,F ALSE),MATCH(ColumnHeaderToFind,ColumnHeaders,FALSE )) Like this =INDEX(A1:AL38,MATCH("Label 16",A1:A38,FALSE),MATCH("Header 23",A1:AL1,FALSE)) to find the intersection in the table of Label 16 and Header 23, with the table in A1:AL38...... HTH, Bernie MS Excel MVP "R.A. Clarke" <R.A. wrote in message ... Tried Vlookup, Hlookup, =if, Index, etc., but would need 37x37 variables per line of formulae. Macro would also be too long. Friend of mine suggested Visual Foxpro. Any chance of an Excel solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading columns and rows in selected range | Excel Programming | |||
| reading data from columns that span rows | Excel Programming | |||
| Excel Convert Multiple Rows into Multiple Columns | Excel Programming | |||
| Excel Convert Multiple Rows into Multiple Columns | Excel Worksheet Functions | |||
| Pivot tables, using rows instead of columns | Excel Programming | |||
Linear Mode
