G
Guest
I'm trying to learn formulas but not having much luck. Here's what I have.
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
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