formula stops working after certain range

[Diogo2]

Hello

I am using the formula below

Please Login or Register  to view this content.

to get the value of gene expression of Patient "GTEX-11EM3" and the Gene "PARP1" from the sheet "female" to the sheet "computing sheet female" to build a table in a format another statistic software will accept.

The code seems to be working perfectly, however, after line 106 on the sheet "computing sheet female" it stops working, and doesn't return the value I want.

I have fumbled with the code and the table a lot and I have no idea why it stopped working.

Any idea why it stopped working or any alternative way to build the table in the way I need?

[Bo_Ry]

Please try at B3
=IFERROR(LOOKUP(1;1/(female!$A$2:$A$108=$A3)/(female!$B$2:$B$108=B$2);female!E$2:E$108);"")

[Diogo2]

Thanks! It is working perfectly now