Stumped! - Need to associate a users phone extension with their name and populate fileds from this

[funkenstein]

Hi All,

Please can anyone help me - i'm rubbish at Excel and i don't have the correct terminology to search for help on the following

I have an excel sheet with 2 pages:

Page one contains 2 columns 1= username 2=phone extension number
Page two contains 3 columns 1= Huntgroup name 2= Huntgroup Extensions number 3= Contains huntgroup members extension numbers

What i am trying to achieve is to associate the extension number with the username on page 1.

I then need to populate the username into column 3 on page 2. This will show the users who are huntgroup members rather than just their extension number as it currently does.

Is this possible with Excel? It's a long list so being able to do this will be a real timesaver!

Thanks in advance for any advice

 

[mole999]

post some examples of row formats

are the numbers text or numbers

a simple vlookup should do it

are there spaces at either end of names or numbers, I presume you only want exact match

 

[funkenstein]

post some examples of row formats

are the numbers text or numbers

a simple vlookup should do it
are there spaces at either end of names or numbers, I presume you only want exact match

yes i need only an exact match - thanks for your help

the username is text and the telephone extensions are numbers. I can't seem to post an image to the thread soi i'll add one when i work out how to do it

 

[funkenstein]

and the only space is between first and last name of the user

 

[mole999]

try =INDEX(A2:A4,MATCH(123,B2:B4,0)) (placed on sheet 2 where you want the name to appear

so B2 to B4 is on sheet 1 which is your phone extension number

A2 to A4 is on sheet 1 which is your names for reference

123 could be a cell reference for the extension you are referencing on sheet 2

does that help, extend A and B as required