Excel Match Help

  fermerboy 12:48 11 May 2004

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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Comment suivre le parcours du père Noël ?