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.
Bookmarks