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.
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...