Thread: Match and Index Formula

First of all thanks for the help before we start. I have a real file that is similar to the dummy file I will attach to this post. Onto the file:

The file I am giving, as you can see has 14 columns but only 2 are going to be used. What I want to do is look up the class first on the table sheet, Then from the class I want to lookup the amount shown in column J. In the step column( N), I want it to return the header (start, Step 1, etc.) from the table sheet from where we looked up the previous 2 lookups. If you could help I would appreciate it. Any questions ask.

Thanks,
Ryan

in N2, try:

=INDEX(Table!$B$1:$E$1,MATCH(J2,Table!$A$2:$A$8,0),MATCH(D2,INDEX(Table!$B$2:$E$8,MATCH(J2,Table!$A$2:$A$8,0),0)))

copied down.

One too many functions...

Try:

=INDEX(Table!$B$1:$E$1,MATCH(D2,INDEX(Table!$B$2:$E$8,MATCH(J2,Table!$A$2:$A$8,0),0),0))

copied down.