using index and match --problem with formula-- sometimes get a match and sometimes when there is data in the table get N/A

[cgat]

					​	​	​
worksheet table​					​	​	​
y x 0.1​ 0 (0.1) (0.2) (2.3)​ (0.2769) (0.1216) (2.4)​ (2.5)​ 0.0167 (0.0624) (2.6)​ (2.7)​ 0.0698 (0.1279) 0.0923 (2.8)​ 0.0692 (0.1111)					​	​	​
​					​	​	​
​	predictions		formula used		​	​	​
​	y x prediction -2.3​ -0.1​ -0.12162​ -2.3​ 0​ -0.2769​ -2.5​ -0.2​ #N/A​ -2.5​ 0​ 0.016675​ -2.7​ -0.2​ #N/A​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​		=INDEX($K$37:$P$43,MATCH(T36,$K$37:$K$43,0),MATCH(U36, $K$37:P$37,0))		​	​	​
I cannot figure out what I am doing wrong. I would greatly appreciate any help.​					​	​	​
					​	​	​

 

[cgat]

The index formula is referencing the cells in the first table. The first table has the if statement in its cells.
The values (such as -0.2769 and -0.1216 in the first row of the first table) have the if statement in their cells.
The first table was referencing another table which you have not seen that had a bunch of DIV/0 errors when the averages were being generated,
so I generated the table you have seen because I was trying to get rid of DIV/0.

I think, maybe naively, the issue is with the index formula. Maybe the problem is with my if statement in the table that is being referenced to get the prediction.
I do not understand why sometimes the index statement works when referencing cells and sometimes it does not. I am currently sorting all the columns to get rid
of the cells (make them totally blank) that have "" from the if statement.

 

[cgat]

Ahoy NC ,

I just realized I did not answer your original question. The formula in the cell giving the #N/A was the original formula that I posted. All the formulas in the prediction col
were copy and pasted from the first cell in the column.

Thank you so much for your help.

 

[AhoyNC]

I think your INDEX formula is fine. The issue could be from the DIV/0 errors.