Search results

Even better, I did this: =IF(ISERROR(INDEX(Sheet2!$B$2:$E$11,MATCH(Sheet1!A4, Sheet2!$A$2:$A$11, 0), MATCH(Sheet1!K4, Sheet2!$B$1:$E$1, 0)))=TRUE,"",INDEX(Sheet2!$B$2:$E$11,MATCH(Sheet1!A4, Sheet2!$A$2:$A$11, 0), MATCH(Sheet1!K4, Sheet2!$B$1:$E$1, 0))) So now no more ugly NAs and it only...

I figured it out! I had to start on a new workbook and copy the info, because apparently at one point I had put on protections that were just messing everything up. But I ended up with this formula: =INDEX(Sheet2!$B$2:$E$11,MATCH(Sheet1!A4, Sheet2!$A$2:$A$11, 0), MATCH(Sheet1!K4...

Hmm. That didn't quite work as expected. I've uploaded the file here: http://speedy.sh/J9n2a/Rorschach-Sequence-of-Scores.xlsx I tried using a combo of INDEX and MATCH, based on something I saw on another site, because there aren't always the same amount of responses per card. So there...

This is an introduction and question post all in one. Hi there, I'm a newbie to this site and a total noob with Excel. Well, not total, but easily confused by formula jargon. I am trying to create a Rorschach (inkblot test) scoring worksheet to help make my life easier. But of course it is...