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?

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?