Excel name match querySolved/Closed

Question

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! 



Configuration: Windows XP / Internet Explorer 8.0

rizvisa1 · Accepted Answer

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

rizvisa1 · Answer

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

Guest user · Answer

Thank you, rizvisa1! This helped me today.

Excel name match query

3 responses

Similar discussions

Subscribe To Our Newsletter!