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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…