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

funkenstein

New Member
Joined
Sep 16, 2014
Messages
3
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 :)
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

New Member
Joined
Sep 16, 2014
Messages
3
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 :)
 
Last edited:

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,447
Messages
5,528,803
Members
409,837
Latest member
karnasrinivas
Top