Is there any way to set the predictive text for a column/cell to refer
to a range?

Example:

My list is in Column E. (E1:E50)

Mary
Bob
James
Larry
Kevin

Whenever someone begins typing a name in A1, it searches and finishes
the name.

Kev


I know that Excel predicts sometimes, but not consistent. I want to
predict based on a set criteria.