down and across- help!

**tspevak** · 02-19-2013, 09:33 PM

I'm working on taking raw data placement test scores to course placement action. I have figured out 95% of what I need to do. I have a worksheet with various "if-then" statements. I've attached a sample of what I'm trying to do in simple terms.

I've gotten as far being able to take the one set of data to get me the colors across the top, and the other set to get me the letter down the side.

I'm stuck on how to tell excel to go across a specific letter row (basic math score calculated), to a specific color column (adv. math score calculated), and return the number (placement course) they have in common, putting it in a different sheet.

I know how to get the number where I want it once I have it, I just can't tell it to go down and over at the same time.

Any ideas?? Thanks.

**Pete_UK** · 02-19-2013, 09:53 PM

Suppose you have orange in I2 and f in J2, then you can put this formula in K2:

=INDEX($B$2:$F$10,MATCH(J2,$A$2:$A$10,0),MATCH(I2,$B$1:$F$1,0))

which will return the number at the intersection of the f row and the orange column (5).

Hope this helps.

Pete

**alansidman** · 02-19-2013, 10:01 PM

Look at the attached for an alternative solution

**tspevak** · 02-19-2013, 10:42 PM

Thanks Pete....that didn't work exactly, but with some tweaking, I think I have it. Going to test some different data sets with it. SOOOO much appreciated!