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 :)
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

mole999

Well-known Member
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

Well-known Member
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,652
Messages
5,838,610
Members
430,557
Latest member
MK15

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