Sub M_snb() Cells(1).CurrentRegion.Columns(4).SpecialCells(4) = "=RC[-1]" End Sub
=INDEX($D$1:$D$4;IFERROR(MATCH($F2;$A$1:$A$4;0);0)+IFERROR(MATCH($F2;$B$1:$B$4;0);0))