Simple Formula Needed

[JAMIESTAHL]

I am not heavy Excel user but I need a way to enter some data as follows.

I want to have a list of names on one sheet and on a second sheet I want enter a number in to a cell and have a name from the first sheet appear instead of the number.

For example:
John Smith = 1
Joe Blow = 2

So when I enter 1 on the second sheet the name John Smith will appear in that cell.

Greatly appreciated.

 

[texasalynn]

Welcome to MrExcel board..
Do you have a number assigned to the names? Or are you just wanting from the number the name from that order? John being 1 and Joe being 2

 

[T. Valko]

I am not heavy Excel user but I need a way to enter some data as follows.

I want to have a list of names on one sheet and on a second sheet I want enter a number in to a cell and have a name from the first sheet appear instead of the number.

For example:
John Smith = 1
Joe Blow = 2

So when I enter 1 on the second sheet the name John Smith will appear in that cell.

Greatly appreciated.

See this...

http://contextures.com/xlFunctions02.html

 

[Armando Montes]

Vlooup will do it, see this:
http://office.microsoft.com/en-us/starter-help/vlookup-function-HP010343011.aspx?CTT=1

 

[Aladin Akyurek]

Sheet2

E2: 2

F2:

=INDEX(Sheet1!$A$2:$A$100,E2)

which fetches the name on the 2nd cell in A2:A10 on Sheet1.

Is this what you are after?

 

[JAMIESTAHL]

I would like to have a number associated with the name.

There is 18 names on the name list.

The goal is not to have to type the names each time on the second sheet. I just want to be able to type the number in the cell and have the name appear instead. I want to be able to assign different names to a list of projects on the second sheet.

I hope this makes it more clear.

Thanks again.

 

[JAMIESTAHL]

Thanks every one for you help. The VLOOKUP function did what I needed.

 

[T. Valko]

Thanks every one for you help. The VLOOKUP function did what I needed.

Thanks for the feedback!