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.