Schedule setup

[medic63]

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?

 

[Aladin Akyurek]

(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]

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

 

[Aladin Akyurek]

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
	A	B	C	D	E	F
1
2	1	Tom
3	2	Bob	LightGreenareaisnamedNameList
4	3	Beth
5
6
7
8
9	2	Bob
10
Sheet1

 

[medic63]

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

 

[Aladin Akyurek]

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]

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??

 

[PaddyD]

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).

Paddy