Hi all,

I'm at my wits end with this spreadsheet and could really use help. I'm a
newbie, and I have a worksheet 1 with 4 columns I need to factor. Each row
(from 2-501)one sheet 1 is a for a different student and each column factors
a specific test score. The columns I need to factor (which are I,J,R and U)
contain a Y or N (the value returned from a formula) if the specific test
score meets the criteria.

Now, I also have a sheet 2 in the same workbook, which contains multiple
lookup tables for the other formulas in sheet 1. What I am trying to do is
formulate a 2 column lookup table on sheet 2. Column 1 would be Y or N based
on matching a combination (see below) thus being TRUE or FALSE, and column 2
lists the recommendation for the combination that was matched.

Then, in a cell in the appropriate student's row on Sheet 1 put the
recommendation that matched the test result combination. Does that make
sense?? Here's my visual:

Column 1
Column 2

If I2="Y" and J2="N" and R2="Y" and U2="Y" "Book A, Unit 1"
If I2="Y" and J2="N" and R2="Y" and U2="N" "Book A, Unit 1"
If I2="Y" and J2="N" and R2="N" and U2="Y" "Book A, Unit 1"
If I2="Y" and J2="N" and R2="N" and U2="N" "Book A, Unit
1 w/emphasis on steps 3-6"
If I2="N" and J2="Y" and R2="Y" and U2="Y" "Book C, Unit
13"
If I2="N" and J2="Y" and R2="Y" and U2="N" "Book C, Unit
13"
If I2="N" and J2="Y" and R2="N" and U2="Y" "Book C, Unit
13"
If I2="N" and J2="Y" and R2="N" and U2="N" "Book C, Unit
13 w/emphasis on steps 3-6"
If I2="N" and J2="N" and R2="Y" and U2="Y or N" "Book C, Unit
13 w/emphasis on steps 1,2"
If I2="N" and J2="N" and R2="N" and U2="Y or N"
"Review/Acceleration Books C-F"

I need this to work seperately for each student (row), not just for row 2. I
had each IF statement on a seperate row on sheet 2, and a lookup on sheet 1,
but can't figure how to make it work for each row. Should I use an INDEX,
OFFSET, or MATCH entry?? I'm not familiar with those yet. Or, Maybe I'm
just dazed from looking too long.

ANY and ALL help is EXTREMELY appreciated!!!

Deborah