Combining IF Statements

[RaydenUK]

How would I combine these 4 IF statements into one?

=IF(A2="A",IF(ISNUMBER(MATCH("B",$A$2:$A$21,0)),"B",A2),A2)
=IF(B2="D",IF(ISNUMBER(MATCH("E",$A$2:$A$21,0)),"E",B2),B2)
=IF(C2="L",IF(ISNUMBER(MATCH("O",$A$2:$A$21,0)),"O",C2),C2)
=IF(D2="F",IF(ISNUMBER(MATCH("K",$A$2:$A$21,0)),"K",D2),D2)

Any help would be greatly appreciated

[6StringJazzer]

Depends on how you need to combine. The first conditions in each formula are not mutually exclusive conditions. For example, what do you want to return if A2="A" and the MATCH returns a number, and also B2="D" and that MATCH returns a number? In the extreme case, what if all eight conditions are TRUE? What if all eight conditions are FALSE?

If you can sort out the order of precedence to evaluate the conditions, then the formula practically writes itself.