Excel Match Help

  fermerboy 12:48 11 May 04
Locked

Hi All
What I'm stuck on is this, I have a table 5 columns by 5 rows and I want to specify which column to use and then match in in that column to give me the row number of the match.
The table is in the range A1-E6(including headings, so =MATCH(A10,A1:E1,0)gives me the column number that I want by inserting the column heading in cell A10. What I want then is to look down that column for a match with cell A12 to give the row number as answer,I can make index do everthing else I need to do. I have tried match again but you have to say the range which changes based on the first answer. There is probably something really easy that I'm missing.

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017