Previous Topic Next Topic

Excel name match query

Solved/Closed
sarah - Jun 16, 2010 at 06:27 AM
 Guest user - Jun 1, 2011 at 08:48 PM
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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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))
3
sarah
Jun 16, 2010 at 11:28 AM
wow! thanks!! that has just made my life a WHOLE lot easier!!! Thank you!!
0
Answer 2 / 3
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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
0
sarah
Jun 16, 2010 at 07:52 AM
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!
0
Answer 3 / 3
Guest user
Jun 1, 2011 at 08:48 PM
Thank you, rizvisa1! This helped me today.
0