Linking a name to a number

**buzza182** · 02-12-2013, 07:38 AM

Sorry if this is extremely simple i just cant get my head around it.....

On one sheet I have a list of names and numbers next to them i.e.

1,Paul
2,Sam
3,James

On sheet 2 I want to type number 1 in a cell and paul pops up in the cell next to it

Please help!!

**Max, Singapore** · 02-12-2013, 07:53 AM

One way
Assume your source data as indicated is in Sheet1, in cols A and B, where col A = nums, col B = names
In Sheet2,
Your list of nums is running in A2 down
Put this in B2: =VLOOKUP(A2,Sheet1!A:B,2,0)
Copy down
----------------
Any worth? Hit the little star at the bottom left of my responses

**Kevin UK** · 02-12-2013, 07:56 AM

Hi buzza182

VLOOKUP, see the attached file.

**buzza182** · 02-12-2013, 08:04 AM

Perfect thanks to the both of you!!

just so i understand what does the ,2,0) bit mean???

**Kevin UK** · 02-12-2013, 08:09 AM

Hi

2 is the column in which the value to be returned is in and range lookup, 0 = exact match. see the link below.

http://www.myonlinetraininghub.com/e...ulas-explained