# Schedule setup

#### medic63

##### New Member
I have an excel sheet that is used to make up a monthly working schedule for 15 employees
what I want to do is have the sheet pick the name from the list and fill it in

each employee has a number associated to there name 1 = Tom, 2= Bob, 3= beth ect...

when I enter 1 into a cell Tom's name pops in 2 and its Bob ect How do I set this up?

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

##### MrExcel MVP
(1.) Create 2-column list of numbers and names.
(2.) Select all the cells of this list.
(3.) Go to the Name Box on the Formula Bar.
(4.) Type NameList and hit enter.

Now you use:

=VLOOKUP(A1,NameList,2,0)

to get the name associated with the number in A1.

#### medic63

##### New Member
Could not get it to work, little more instruction I am an excel idiot almost need step by baby step

##### MrExcel MVP
On 2002-09-29 11:15, medic63 wrote:
Could not get it to work, little more instruction I am an excel idiot almost need step by baby step

Read the Help file if my instructions are insufficient... and see:
Book9
ABCDEF
1
21Tom
32BobLightGreenareaisnamedNameList
43Beth
5
6
7
8
92Bob
10
Sheet1

#### medic63

##### New Member

I am still having problems with the vlookup on the list

I am trying to enter a number in colum A that corrisponds with the name in colum B but I cant get the formula to work I am doing somthing wrong but dont know what it is
I want the name to enter in a cell on a sheet that is a schedule for a month with four people working days and four on nights for 7 days a week open to suggestions

Thanks Tomas

##### MrExcel MVP
On 2002-09-29 14:11, medic63 wrote:
I am still having problems with the vlookup on the list

I am trying to enter a number in colum A that corrisponds with the name in colum B but I cant get the formula to work I am doing somthing wrong but dont know what it is
I want the name to enter in a cell on a sheet that is a schedule for a month with four people working days and four on nights for 7 days a week open to suggestions

Thanks Tomas

Put the list in a separate sheet and name it as I described. After you have done that correctly, you can in the worksheet housing your schedule enter a number, say in A2, and the formula in B2:

=VLOOKUP(A2,NameList,2,0)

will put the name in B2 which will correspond to the number in A2.

#### medic63

##### New Member
I still have a problem

This is what I have done

Created two colums A1 to A15 with numbers and B1 to B15 with the names
Hilighted the two colums and renamed the page NameList

What i dont know is where do i put the formula =VLOOKUP(A1,NameList,2,0)

Does this formula go into evey empty spot on the schedule or what do i do with it??

##### MrExcel MVP
In your original dpost, you said:

"when I enter 1 into a cell Tom's name pops in 2 and its Bob ect How do I set this up?"

You have 2 options:

1) Have one cell where you put the numbers, and another cell where the corresponding names pop up. If this is OK, then put the formula you've got in a cell next to the cell where you are putting the numbers, or in general in whatever cells you want to see in names.

2) You can't enter data & have a formula in the same cell. So you could not use a formula to put, e.g., a 1 in a cell & have it 'become' Tom etc. to do that you'll need vba.

Unless you've got a really good reason not to, I'd go with option (1).

Replies
2
Views
72
Replies
5
Views
171
Replies
3
Views
164
Replies
0
Views
224
Replies
1
Views
306

1,147,823
Messages
5,743,409
Members
423,792
Latest member
travisds

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back