G

#### Guest

I have a total of 7 columns and 9 rows of numbers like this shown below.

A B C J K L M

0 0 1 10 10 10 10

0 0 1 10 10 10 10

0 0 1 10 10 10 10

2 1 0 8 8 8 8

2 1 0 8 8 8 8

2 1 0 8 8 8 8

2 0 1 20 20 20 20

2 0 1 20 20 20 20

2 0 1 20 20 20 20

Here is what I want: Whenever column A=2, B=0, and C=1 then in a cell on

sheet 2 I would like the first value in column J when this is true to show

up (which would be the number 20).

Here was my formula:

IF(AND(Sheet1!$A$1:$A$9=2,Sheet1!$B$1:$B$9=0,Sheet1!$C$1:$C$9=1),Sheet1!$J:$J9)

This formula gives an error which I can't figure out. Maybe I'm going at

this all wrong. Would appreciate any help