Excel: reading tables with multiple rows and columns

  • Thread starter Thread starter R.A. Clarke
  • Start date Start date
R

R.A. Clarke

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?
 
R.A.,

=INDEX(TableArray,MATCH(RowLabelToFind,RowLabels,FALSE),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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Find last column & copy/paste values 1
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2
using hlookup to reference a column in a vlookup formula? 3
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Find and match text and return column and row reference 0
Problem with a loop and column references 27
Changing a Formula Variable 4

Back
Top