How do I read through a column with four names in it

[bdw72]

How do I read through a column with four names in it, and simply put a name in the cell I am at. I want to enter the word Green in A1 and I want A2 to be Yellow, A3 to be Black, A4 to be RED and so on. But i want the cell to populate from the Table. I am nopt sure how to do this, and I really appreciate your help. Example below:

A Table
1 Green (I enter the first word) Red
2 Yellow Green
3 Black Yellow
4 Red Black
5 Green
6 and so on.....


Thanks,
Brian

 

[bdw72]

Looks like the Table I entered lost it's formatting, it should look like this:



Red
Green
Yellow
Black