Excel name match query
Solved/Closed
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!
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!
Related:
- Excel name match query
- Music match jukebox - Download - Audio playback
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- How to change author name in excel - Guide
- Kernel for excel - Download - Backup and recovery
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2010 at 09:45 AM
Jun 16, 2010 at 09:45 AM
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))
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))
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2010 at 07:03 AM
Jun 16, 2010 at 07:03 AM
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
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!
https://authentification.site/files/22985578/Example_file.xlsx
Hope i've explained myself well enough...
Thanks!
Jun 16, 2010 at 11:28 AM