Hi, Im absolutely stumped on how to deal with #NA errors when looking up a range and there is no lookup value present. Below is a portion of the multipe IF statements within this cell.

=

IF(AND(R8="Y2",LOOKUP(2,1/($R$3:$R7<>""),$R$3:$R7)="XY2"),LOOKUP(2,1/($R$3:$R7="Y2"),$Q$3:$Q7),

IF(AND(R8="X2",LOOKUP(2,1/($R$3:$R7<>""),$R$3:$R7)="XY2"),LOOKUP(2,1/($R$3:$R7="X2"),$Q$3:$Q7),

I didnt think I could use IFNA or IFERROR because the other IF statements wont use the IFNA false option.