If function, false, blank.... need help!!

[flec011]

CC rubric.xlsThere is my problem:

I have an evaluation sheet with 2 main columns (column A, column B), which I will fill with sentences from another sheet using IF function unless there’s something better.

My other sheet is working like this:

I have to attribute a score (1 to 5), and each score have a sentence attach to it… So for scores 1 and 2, I want those sentences to go in column B, AND 3, 4, 5, goes in column A.

I have 25 blocks that I have to put scores 1 to 5.

So I’m looking for:
- each sentences to go in their respective column (A or B);
- if a sentence is in column B, I want a blank in column A, BUT if I put another sentences in column A, I don’t want a big BLANK space before.
- I want the sentences in each column to follow each others like normal text.
- I have to print 2 sided sheets, so if one side is full, I want it to go on the other side.

It’s a lot to ask, but I need an expert, because I’m stuck!!

Thank you

[TMS]

Where is the score?

Let's say, for argument's sake, it's in column C. And maybe the sentences are in column D.

In column A, you could have:

=IF(AND($C2>=3,$C2<=5,INDEX($D$1:$D$5,$C2),"")

and copy down. Similarly for column B.

=IF(AND($C2>=1,$C2<=2,INDEX($D$1:$D$5,$C2),"")

Regards, TMS

[flec011]

I was using this formula in my column B:

=IF(PP!A5=1,PP!C5,IF(PP!A5=2,PP!C6))&" / "&IF(PP!A13=1,PP!C13,IF(PP!A13=2,PP!C14))&" / "&IF(PP!A21=1,PP!C21,IF(PP!A21=2,PP!C22))

this was only for 1 of the 25, and i had FALSE problem appearing in the column A...

My column A & B are in one sheet, and my scores are on a different tab sheet!

So i just have to erase my formula and write down the one you suggest?

[TMS]

You don't have to do anything. I was posing a possible answer based on a somewhat "open" description of your problem.

If you look at your description of the problem, I think you'll find there is no mention of the structure of your workbook, the layout of the sheets, the location of data and formulae, or the formulae themselves.

I was trying to be helpful without just saying "please post a workbook". Clearly, I should have said just that.

If you don't understand the formula that I have suggested, what it does or where it should go, you shouldn't just type it in. I'm guessing it will need some modification.

Regards, TMS