IFS with VLOOKUP help

You can use this shorter and more structured formula:

=IF(
   OR(
      AND(COUNTIF('Dropdown list'!N:N, F3), COUNTIF('Dropdown list'!N:N, F4)),
      AND(COUNTIF('Dropdown list'!O:O, F3), COUNTIF('Dropdown list'!O:O, F4)),
      AND(COUNTIF('Dropdown list'!P:P, F3), COUNTIF('Dropdown list'!P:P, F4)),
      AND(COUNTIF('Dropdown list'!Q:Q, F3), COUNTIF('Dropdown list'!Q:Q, F4)),
      AND(COUNTIF('Dropdown list'!R:R, F3), COUNTIF('Dropdown list'!R:R, F4))
   ),
   "yes",
   "no"
)

If 1st value is in column N and 2nd value is in column N, then return "yes" if not then return "no".  This is how I would like this to work.  Thoughts?

=IF(AND(COUNTIF('Dropdown list'!N:N,F3), COUNTIF('Dropdown list'!N:N,F4)),"N",
 IF(AND(COUNTIF('Dropdown list'!O:O,F3), COUNTIF('Dropdown list'!O:O,F4)),"O",
 IF(AND(COUNTIF('Dropdown list'!P:P,F3), COUNTIF('Dropdown list'!P:P,F4)),"P",
 IF(AND(COUNTIF('Dropdown list'!Q:Q,F3), COUNTIF('Dropdown list'!Q:Q,F4)),"Q",
 IF(AND(COUNTIF('Dropdown list'!R:R,F3), COUNTIF('Dropdown list'!R:R,F4)),"R",
 IF(OR(COUNTIF('Dropdown list'!N:R,F3), COUNTIF('Dropdown list'!N:R,F4)),"partial","no"))))))

Hope I was able to help you with this information.