I proposed this equation in cell A3: =IF(A2="John",NAMES)

John being the words that populate A2 and NAMES being the name of the list
created. For the sake of the example, the list NAMES contains Smith, Jones,
and Williams. The problem is, instead of populating the full NAMES drop
down, the cell only populates the first cell involved in the drop down (i.e.,
Smith). It gives me no option to select one of the names in the drop down.

Is there a way around this?