Schedule setup

medic63

New Member
Joined
Sep 12, 2002
Messages
13
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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
(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
Joined
Sep 12, 2002
Messages
13
Could not get it to work, little more instruction I am an excel idiot almost need step by baby step
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
Joined
Sep 12, 2002
Messages
13

ADVERTISEMENT

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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
Joined
Sep 12, 2002
Messages
13
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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
 

Forum statistics

Threads
1,144,439
Messages
5,724,369
Members
422,547
Latest member
Vision1291

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top