I sure this is an easy one and has been posted may times, but could not
find a post that matches, or even what to call this other than
autofill.

If I was to enter 1 anywhere in column a
I would like Cook to appear in the first cell to the right and Rob to
appear in the second cell to the right.

If I was to enter 2 anywhere in column a
I would like Woo to appear in the first cell to the right and Jim to
appear in the second cell to the right.

If I was to enter 3 anywhere in column a
I would like King to appear in the first cell to the right and Tom to
appear in the second cell to the right.

If I was to enter 4 anywhere in column a
I would like Fish to appear in the first cell to the right and Al to
appear in the second cell to the right. and so on.

Reference table
1 Cook Rob
2 Woo Jim
3 King Tom
4 Fish Al

Could someone please refer me to a link that can explain how to do
this.

Thanks