Excel Match Help

  fermerboy 12:48 11 May 2004
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.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?