Autofill question

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

VLOOKUP is what you need to use. These examples will help:

http://www.contextures.com/xlFunctions02.html
http://www.techonthenet.com/excel/formulas/vlookup.htm

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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
>
>.
>

Thanks for the help, the tech on net site has good explanation for a
rookie like me.
Lob