EXCEL HELP:

Sheet 1: I have a MasterSheet with all client's names:

Sheet 2: It's a january monthly sheet with a column named as client.

PROBLEM:

I have a Master spreadsheet that lists all clients separately and when I start to type a client into a monthly spreadsheet I would like it to autofill if they are already in client list within the Master sheet or not. So how can I check this for each month separately from the MasterSheet list?

\begin{tabular}{|c|} \hline CLIENT LIST \\ \hline John \\ \hline Kim \\ \hline William \\ \hline Henry \\ \hline Shein \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} Client