IFNA Formula

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.

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.