if and index and matching

[mathbish]

I'm trying to have an if then, and and and index matching scenario all work in one formula. I have looked online and tried to manipulate the information according to my data but I can't get it to work how I need it to.

I will try to explain the best I can. I think it will be easier with the data info: (this is column A and B respectively)

Number of Tardies 3
Number of G's 5


If the above two numbers are less than 6 I need it to check another set of data which I have in 3 columns: (this is column I, J and K respectively)
G T Arcs
1 1 0
1 2 0
1 3 0
1 4 0
1 5 0
1 6 1

I need it to take the number of G's from the first data and the number of T's and match it to the set of three columns where the g's and t's match and then spit out the number in the third column.

If the two numbers on the first data set is not less than or equal to six I need it to say 0 in the spot that it would tell me what was in the third column.

I can get it to match the g's and t's and output the arcs correctly but when I try to say if the g's and t's are more than six put zero and if they are less than six then match with the three column data.

I currently have =IF(AND(B4<6.5,B5<6.5),INDEX($K$2:$K$37,MATCH(B4&B3,$I$2:$I$37&$J$2:$J$37,0)),0)


Please help. I'm trying to be effective and save time in our school. Any help or redirection would be appreciated.

Thanks,

Kristen

[wallyeye]

If your numbers in A & B are actually numbers, just do an arithmatic index:

=IF(AND(B4<=6,B5<=6),INDEX($K$2:$K$37,(B4-1)*6+B5),0)