Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Excel name match query [Solved/Closed]

Report
-
 Guest user -
Hi

I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list of some of those staff (that have made a call to a helpdesk). These staff don't have a telephone number appended, so I need to match the staff in Column C to the Staff in Column A, and also make sure the equivalent telephone number sits along side aswell.

Thanks!



3 replies

Answer 1 / 3
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 765
You have to use VLOOKUP


This is for for D2, you can add it to E2 if you want and then drag it down
=IF(ISERROR(VLOOKUP(D2,B:C,2, FALSE)),"",VLOOKUP(D2,B:C,2, FALSE))
3
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

wow! thanks!! that has just made my life a WHOLE lot easier!!! Thank you!!
Answer 2 / 3
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 765
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Report

Hi, here's the file. The information is 'fake'. I want to match the names in the last column to the names in the second column, and when matched I can then see their telephone numbers and departments along side...

https://authentification.site/files/22985578/Example_file.xlsx

Hope i've explained myself well enough...

Thanks!
Answer 3 / 3

Thank you, rizvisa1! This helped me today.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!